Re: [ADMIN] replication solution

2010-10-13 Thread Simon Riggs
On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote: > Hi all, > > we are looking for a solution to create a replicated database to be used > as reporting database with same data of production ( we can accept a lag > of some minutes). > > we already have the Point In Time Recovery but we n

Re: [ADMIN] Cannot connect to database

2010-10-13 Thread Lennin Caro
--- On Wed, 10/13/10, Ozer, Pam wrote: From: Ozer, Pam Subject: [ADMIN] Cannot connect to database To: pgsql-admin@postgresql.org Date: Wednesday, October 13, 2010, 4:48 PM   All of a sudden yesterday my Postgres Service stopped on my local connection.  I was able to restart th

Re: [ADMIN] [GENERAL] Copying data files to new hardware?

2010-10-13 Thread Tom Lane
Jaime Casanova writes: > On Wed, Oct 13, 2010 at 11:03 AM, EDH wrote: >> What I'd like to know is: if I install the latest 8.2.x release - I >> see 8.2.18 RPMs are available - can I do a straight copy of the >> contents of /var/lib/pgsql/data/ to the new server and start it up? >> Or is dump & re

[ADMIN] Cannot connect to database

2010-10-13 Thread Ozer, Pam
All of a sudden yesterday my Postgres Service stopped on my local connection. I was able to restart the service in PGAdmin but now I can't connect to the database through PGAdmin. My application can still connect but I can't. It keeps asking for my password and I enter it but it keeps saying

Re: [ADMIN] [GENERAL] Copying data files to new hardware?

2010-10-13 Thread Jaime Casanova
On Wed, Oct 13, 2010 at 11:03 AM, EDH wrote: [...] > > What I'd like to know is: if I install the latest 8.2.x release - I > see 8.2.18 RPMs are available - can I do a straight copy of the > contents of /var/lib/pgsql/data/ to the new server and start it up? > Or is dump & restore the only real wa

Re: [ADMIN] installation failed for PostgreSQL 9.0.0 in Windows (Visual C++ Runtime Installation error)

2010-10-13 Thread Josi Perez (3T Systems)
I had this error and the same condition listed and solved the problem including an extra parameter when calling the program postgresql-8.4.2-1-windows.exe --install_runtimes 0 (substitute by the right exe) I hope solve your problem too, Josi Perez 2010/10/7 Kiswono Prayogo > > Error: Visual

[ADMIN] Merge similar databases

2010-10-13 Thread Joy Martin Omello
Hi I have a system running postgresql that I have installed on two different servers. My challenge is that I need another server that I can install the same system but to be in position to combine the three different but similar structure postgresql databases to have one main database. I have a p