Re: [ADMIN] I neen help establishing a connection to my PostgreSQL database.

2005-02-01 Thread Bender, Cheryl
By default the postmaster in Windows listens for TCP/IP connections only on the loopback interface.     Take a look at your conf files (postgresql.conf and pg_hba.conf).  Postgresql.conf probably needs to have a line added something like this:   listen_addresses = '*' # what IP inte

Re: [ADMIN] Online Backup and WAL archives

2005-02-01 Thread Claudio Duffini
"Morus Walter" <[EMAIL PROTECTED]> ha scritto nel messaggio news:[EMAIL PROTECTED] > Hi, > > I'm currently considering to use postgresql 8.0 online backups. > > The documentation says > ' To make use of this backup, you will need to keep around all the > WAL segment files generated at or after the

Re: [ADMIN] Online Backup and WAL archives

2005-02-01 Thread Tom Lane
Morus Walter <[EMAIL PROTECTED]> writes: > The documentation says > ' To make use of this backup, you will need to keep around all the > WAL segment files generated at or after the starting time of the backup. ' > Now I'm wondering how much of these WAL segment files do I really need > in order t

Re: [ADMIN] Online Backup and WAL archives

2005-02-01 Thread Bruno Almeida do Lago
You may need to recreate some indexes: "Operations on non-B-tree indexes (hash, R-tree, and GiST indexes) are not presently WAL-logged, so replay will not update these index types. The recommended workaround is to manually REINDEX each such index after completing a recovery operation." Best Rega

[ADMIN] Online Backup and WAL archives

2005-02-01 Thread Morus Walter
Hi, I'm currently considering to use postgresql 8.0 online backups. The documentation says ' To make use of this backup, you will need to keep around all the WAL segment files generated at or after the starting time of the backup. ' Now I'm wondering how much of these WAL segment files do I re

Re: [ADMIN] I neen help establishing a connection to my PostgreSQL database.

2005-02-01 Thread Magnus Hagander
You don't need to - it's enabled by default on Windows, since it has no support for unix sockets.   //Magnus From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Maurice MenefeeSent: Monday, January 31, 2005 9:28 PMTo: pgsql-admin@postgresql.orgSubject: [ADMIN] I nee