Question : I have two virtual machines: dbrepa (-.175) and dbrepb (-.191). Both have PostgreSQL 9.2 installed; once PG was […]
Tag: postgresql-9.2
PostgreSQL: Executing DDL on every schema
Question : I’ve a multi-tenant DB setup, and need to add some columns. I’m using schemas (and search_path) to partition […]
Sequential scan with large sub-query filter “never” ends
Question : I’m using postgres 9.2.4, and run the following query: explain analyze select * from bubu where id not […]
Performance impact of setting PostgreSQL to log all statements
Question : PostgreSQL 9.2.2 on Windows 7 64-bit. The setting log_statement in the postgresql.conf file specifies what statements to log […]
Upgrading using pg_upgrade on windows fails
Question : When upgrading from postgres 9.2 to 9.3 by following the upgrade procedure found in PostgreSQL 9.3.4 documentation about […]
Streaming replication between postgresql 9.2 and 9.3
Question : Does anyone know if it’s problematic to have a postgresql 9.3 slave setup to do streaming replication from […]
how to track progress of a large postgres dump
Question : Is there a way to see the progress of a pg_dump operation on a big db (ie > […]
Error: Unable to write inside TEMP environment variable path
Question : I am installing PostgreSQL 9.2.4-1-windows.exe on Windows 7 64 with Service Pack 1. I get the following, rather […]
Why does Postgres generate an already used PK value?
Question : I’m using Django, and every once in a while I get this error: IntegrityError: duplicate key value violates […]
pg_ctl status responds with “available” during failed startup
Question : I am using pg_ctl -D $PGDATA status to monitor whether my postgres standby database is up and running. […]