[ADMIN] scheduled switchover

2011-01-10 Thread francois pascual
Hi, I use potgresSQL 8.5 with replication. The primary host and slave host are not in the same place. The bandwidth between master/host is to 10MB. We need to schedule a switchover and I found a solution to use the minimun of bandwith to rebuild the database slave I want to know if somebody use si

[ADMIN] Do I need to run pgagent_upgrade.sql? If so, when?

2011-01-10 Thread Rob Richardson
Greetings! I am putting together a formal installation package for a customer who is not happy if he doesn't have one, even though he's got primary and backup servers both running as expected. I am writing instructions on how to install PGAgent. The download package for PGAgent includes

Re: [ADMIN] saludos y consulta

2011-01-10 Thread IƱigo Martinez Lasala
Hi Alejandro. Your master server is sending WAL segments to slave server. So, each server has its own tables. So, you have to launch an analyze process on both servers in order to get accurate statistics. Anyway, it's not desirable to disable autovacuum. Why to you disable it? If you have a lot o

[ADMIN] problem about postgresql installation and user login

2011-01-10 Thread somnathzankar
hi sir, sorry but I'm in trouble as i don't known exactly but postgresql on a system is reset or remove. so when I'm again trying to install postgresql then follow thing happen.. $ sudo apt-get install postgresql [sudo] password for pragmaticvps: Reading package lists... Done Building dependency