[ADMIN] Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)

2013-08-28 Thread Dana Rea
Dear pgsql-admin, I set up streaming replication using the rsync base backup described in the wiki: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial However, before starting replication I had previously loaded some databases on the Secondary server for testing. Folders for those db's

Re: [ADMIN] Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)

2013-08-28 Thread Stéphane Schildknecht
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Le 28/08/2013 15:50, Dana Rea a écrit : Dear pgsql-admin, I set up streaming replication using the rsync base backup described in the wiki: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial However, before starting replication I had

[ADMIN] Will analyze run on a database affect writes?

2013-08-28 Thread Rajagopalan Ramanujam
At a particular time, when an analyse is run on a database, we are uploading a bulk data from excel sheet. Will the analyse slows down the writes performed at that time? Regards Rajagopalan. RR Rajagopalan Ramanujam DB Admin [cid:logo275dd0]http://repucom.net Phone +91 80 3981 8000 Mobile