Re: [ADMIN] pg_hba.conf stuff

2007-03-01 Thread Rob van der Linde
Yes! that's it, thanks heaps. I had a .pgpass file in the home directory of the client PC. It's possible PgAdmin III or some other program created it. Thanks heaps, now I know it was not actually a security issue with my server. On Wed, 2007-02-28 at 17:15 -0800, Jeff Frost wrote: > On Thu, 1 Ma

Re: [ADMIN] Warm standby (solved)

2007-03-01 Thread Johann Spies
On Tue, Feb 27, 2007 at 10:34:37AM +0200, Johann Spies wrote: > I want to setup a form of replication for postgresql using the warm > standby option > (http://www.postgresql.org/docs/8.2/static/warm-standby.html) > > I have had success to let server A to copy the WAL logs to server B (the > standb

[ADMIN] Day Light Savings Problem

2007-03-01 Thread Pallav Kalva
Hi, As per this article http://people.planetpostgresql.org/greg/index.php?url=archives/96-Is-your-database-ready-for-the-Daylight-Savings-Times-change-of-2007.html&serendipity[cview]=linear#comments, My postgres 8.0.2 database has a problem with the new day light savings time change this mont

Re: [ADMIN] Day Light Savings Problem

2007-03-01 Thread Tom Lane
Pallav Kalva <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED]:/var/lib/pgsql/bin> cd .. > [EMAIL PROTECTED]:/var/lib/pgsql> cd share > [EMAIL PROTECTED]:/var/lib/pgsql/share> /usr/sbin/zdump -v EST5EDT | grep 2007 > EST5EDT Sun Apr 1 06:59:59 2007 UTC = Sun Apr 1 01:59:59 2007 EST > isdst=0 gmtof

Re: [ADMIN] Day Light Savings Problem

2007-03-01 Thread Pallav Kalva
Hi Tom, You are right , I re reran the command now with the whole path it worked. It was looking at the OS time [EMAIL PROTECTED]:/var/lib/pgsql/share/timezone> /usr/sbin/zdump -v /var/lib/pgsql/share/ti

[ADMIN] xlogdump

2007-03-01 Thread Vishal Arora
Hi Does anyone has an idea how xlogdump works with Windows installation of Postgres. I have postgres 8.2.x installed on my windows PC. Thanks Vishal _ Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month.

Re: [SQL] [ADMIN] pg_dump error

2007-03-01 Thread Tom Lane
"Karthikeyan Sundaram" <[EMAIL PROTECTED]> writes: >Thanks for your reply. No, I recently installed (fresh installation) > from scratch. Well, your pg_dump seems to be finding an older version of libpq.so from somewhere. Check for a pre-existing postgresql package.