Re: [ADMIN] PITR WAL backups

2005-02-02 Thread Morus Walter
Mark Reidenbach writes: > The PITR documentation recommends that a user's archive command should > not overwrite an existing wal archive file, but it appears you need at > least the wal archive file that matches the .backup marker for the > recovery process to succeed. This makes sense because

Re: [ADMIN] client authentication problem

2005-02-02 Thread Tom Lane
Dave Vieglais <[EMAIL PROTECTED]> writes: > Contents of pg_hba.conf: > local all postgres ident sameuser > local all allmd5 > host all all 127.0.0.1 255.255.255.255 md5 > host all all 0.0.0.0 0.0.0.0 reject > # tail /var/log/

[ADMIN] client authentication problem

2005-02-02 Thread Dave Vieglais
Hi, I have a problem connecting to a database when using tcp/ip with psql. Connecting with Unix sockets works fine. TCP/IP is enabled, and the log shows a connection is made but authentication is rejected. From the error messages, it appears that the client and server negotiated to use crypt,

[ADMIN] PITR WAL backups

2005-02-02 Thread Mark Reidenbach
The PITR documentation recommends that a user's archive command should not overwrite an existing wal archive file, but it appears you need at least the wal archive file that matches the .backup marker for the recovery process to succeed. This makes sense because the recovery process needs to r

Re: [ADMIN] PostgreSQL Multiple Vulnerabilities

2005-02-02 Thread Darcy Buskermolen
On February 2, 2005 12:00 am, Vishal Kashyap @ [SaiHertz] wrote: > Hi, > > Just found this > > > http://secunia.com/advisories/12948/ This issue has been addressed in 8.0.1, 7.4.7, 7.3.9, 7.2.7 which were all released earlyer in the week. -- Darcy Buskermolen Wavefire Technologies Corp. ph: 2

Re: [ADMIN] Online Backup and WAL archives

2005-02-02 Thread Morus Walter
Pallav Kalva writes: > > If I want to restore to a particular point in time lets say to the > point in time like a day back when one of my table was dropped > accidentally and if i want restore the archive log only to that > particular archive log file . what is the procedure we should foll

Re: [ADMIN] Online Backup and WAL archives

2005-02-02 Thread Pallav Kalva
Hi Tom, If I want to restore to a particular point in time lets say to the point in time like a day back when one of my table was dropped accidentally and if i want restore the archive log only to that particular archive log file . what is the procedure we should follow ? just keep the archi

Re: [ADMIN] Online Backup and WAL archives

2005-02-02 Thread Morus Walter
Tom Lane writes: Thanks for your answer Tom, and also thanks to the others, that answered. > > 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 m

[ADMIN] PostgreSQL Multiple Vulnerabilities

2005-02-02 Thread Vishal Kashyap @ [SaiHertz]
Hi, Just found this http://secunia.com/advisories/12948/ -- With Best Regards, Vishal Kashyap. http://vishalkashyap.tk ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's da