Archives

  • PostgreSQL Remote Connections

    The default value is localhost, which allows only local connections to be made. While client authentication allows fine-grained control over who can access the server, listen_addresses controls which interfaces listen for connection attempts, which can help prevent repeated malicious connection requests on insecure network interfaces. This parameter can only be set at server start. To […]

    Oct 13th, 2018 • Filed under Databases, PostgreSQLPrint View
  • Update MySQL Server Time Zone Data

    I started to get the error message Database returned an invalid value in QuerySet.dates(). Are time zone definitions and pytz installed? from a Django application. These messages presented when I started to utilize date_hierarchy. From the MySQL server run the following command mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -u root -p mysql This will parse the zone […]

    Nov 11th, 2016 • Filed under Databases, Django, Linux, MySQL, PythonPrint View
Archive for the ‘Databases’ Category