388 reputation
115
bio website
location Toronto, Canada
age
visits member for 3 years
seen Aug 28 at 13:58

SQL Server 2005/2008/2012


Aug
28
accepted How to get Identity Column to jump ahead (by say 1000) on SQL Server 2012
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'"