381 reputation
115
bio website
location Toronto, Canada
age
visits member for 2 years, 11 months
seen 6 hours ago

SQL Server 2005/2008/2012


1d
accepted PGAdmin III Server Status Error: Could not read directory “pg_log” No such file or directory
1d
revised PGAdmin III Server Status Error: Could not read directory “pg_log” No such file or directory
added 74 characters in body
1d
asked PGAdmin III Server Status Error: Could not read directory “pg_log” No such file or directory
Aug
16
accepted PostgreSQL Slave has more files in pg_xlog than /wal_archive
Aug
15
comment PostgreSQL Slave has more files in pg_xlog than /wal_archive
I think the slave complaining it couldn't find the 00000001000000000000001C file is actually just part of pg_standby as the slave server is not accepting connections and overall infinitely checking for the latest file to be sent to it. I thought this was an error but likely it was not.
Aug
15
comment PostgreSQL Slave has more files in pg_xlog than /wal_archive
@Craig standby.log was never created or at least nowhere to be found. Ultimately, after various attempts to fix situation above because of failures to start the server, I (you may shudder) deleted the /var/lib/postgresql/9.3/main folder contents on the slave (as much as ubuntu would allow me to delete). Performed base backup on the master and rsynced the contents of /var/lib/postgresql/9.3/main over to the slave. I wonder if the large quantity of log files on Standby were just a side effect of streaming replication. I see in your answer you more or less agree that base backup was needed :)
Aug
15
revised PostgreSQL Slave has more files in pg_xlog than /wal_archive
Added more info - directory names and file names
Aug
15
revised PostgreSQL Slave has more files in pg_xlog than /wal_archive
Portion of changes to make the question more complete
Aug
14
revised PostgreSQL Slave has more files in pg_xlog than /wal_archive
deleted 8 characters in body
Aug
14
asked PostgreSQL Slave has more files in pg_xlog than /wal_archive
Aug
14
comment PostgreSQL streaming versus file-based replication (In terms of server behavior & configuration)
Very helpful, I am wondering if you think this article: blogs.amd.co.at/robe/2009/05/… is on topic with my question. I have been told "log shipping is more stable" and this article seems to share that opinion.
Aug
13
accepted PostgreSQL streaming versus file-based replication (In terms of server behavior & configuration)
Aug
12
revised PostgreSQL streaming versus file-based replication (In terms of server behavior & configuration)
added 88 characters in body
Aug
12
asked PostgreSQL streaming versus file-based replication (In terms of server behavior & configuration)
Jul
29
comment Missing the pg_ctl package in Postgres 9.3 installation
yes, this worked.
Jul
29
accepted Missing the pg_ctl package in Postgres 9.3 installation
Jul
28
revised Missing the pg_ctl package in Postgres 9.3 installation
added 2 characters in body; edited title
Jul
28
comment Missing the pg_ctl package in Postgres 9.3 installation
"The program 'pg_ctl' is currently not installed. To run 'pg_ctl' please ask your administrator to install the package 'postgres-xc'"
Jul
28
asked Missing the pg_ctl package in Postgres 9.3 installation
Jul
2
awarded  Curious