Reputation
428
Top tag
Next privilege 500 Rep.
Access review queues
Badges
6 22
Impact
~30k people reached

  • 0 posts edited
  • 0 helpful flags
  • 43 votes cast
Aug
27
asked How to get Identity Column to jump ahead (by say 1000) on SQL Server 2012
Aug
21
accepted PGAdmin III Server Status Error: Could not read directory “pg_log” No such file or directory
Aug
21
revised PGAdmin III Server Status Error: Could not read directory “pg_log” No such file or directory
added 74 characters in body
Aug
21
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