Question : I have a table with about 10 million rows in it and an index on a date field. […]
Tag: postgresql-9.4
Optimising a query to get rows where x is between pairs of values from another table
Question : PostgreSQL 9.4.5 In my database there are 2 tables, vcfentries and exons. I want to query for rows […]
Why isn’t pg_restore –create working?
Question : I backed up a database called app_data, on a 9.3 server, with this basic command: pg_dump -n public […]
How do you use psql client to connect to a postgresql ipv6 host?
Question : # postgresql.conf listen_addresses=’::’ and # pg_hba.conf hostssl webdb webserver ::0/0 cert The postgresql server is running on docker […]
PostgreSQL doesn’t log
Question : I’m using ArchLinux and PostgreSQL 9.4.4 and have enabled the logging in the config file: $ sudo egrep […]
PostgreSQL – 1 billion rows table cannot get vacuumed despite no errors
Question : I have a statistics table that should be processed in a scheduled task to remove rows and count […]
How to create tablespace if it does not exist
Question : When I create a new schema in Postgres through executing a script in psql I want to put […]
How to reinstall PostgreSQL over an existing installation
Question : I am trying to upgrade an installer created with NSIS that installs postgresql. It used to install postgresql […]
PostgreSQL invalid frontend message type 74
Question : Error invalid frontend message type 74 I’m getting this error and I have no idea where it’s coming […]
Postgres restore unclear behaviour
Question : I have following: 2 nodes one of which is current production db and another is for fail recovery. […]