Re: [ADMIN] pitr standby on slave with skewed time

2008-07-11 Thread Simon Riggs
On Fri, 2008-07-11 at 12:15 -0400, Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > > Was review a clients config/setup and ran across a pitr warm standby > > scenario > > where the master machine is set to the current time, but the slave's time > > is > > currently sitting back in

Re: [ADMIN] pitr standby on slave with skewed time

2008-07-11 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > Was review a clients config/setup and ran across a pitr warm standby scenario > where the master machine is set to the current time, but the slave's time is > currently sitting back in the month of May. Outside of getting ntp setup on > the machine, I am

[ADMIN] pitr standby on slave with skewed time

2008-07-11 Thread Robert Treat
Howdy folks, Was review a clients config/setup and ran across a pitr warm standby scenario where the master machine is set to the current time, but the slave's time is currently sitting back in the month of May. Outside of getting ntp setup on the machine, I am wondering if I need to do anythin

[ADMIN] Access rule listing from the whole database cluster

2008-07-11 Thread Dev
Hi, Is there any way in Postgres to get a list of all the databases and tables which are readable( Select granted ) for a particular user with a single SQL query ? I'm able to get information of all the databases on the cluster owned by a user from the pg_database and pg_roles structures. I'm a

[ADMIN] Password recommendations for an appliance

2008-07-11 Thread niall el-assaad
Hi, I'm developing an appliance that runs postgresql and will be provided to many people. I am wondering on the best way of protecting the database user account. At the moment the account has no password on it, to me this means that the only people who can connect are the application (PHP running

Re: [ADMIN] Importing data - possible UTF8 import bug?

2008-07-11 Thread Mikel Lindsaar
OK, I'm mailing the list the results of my problem so future people can find it. The error was ERROR: invalid byte sequence for encoding "UTF8": 0xa2 with many different types of 0x... lines. The problem was indeed a bug, but one that sat between the keyboard and screen (that is, me), not with

[ADMIN] Database backup problem.........

2008-07-11 Thread neo3 matrix
Hello friends! I m new to this mailing list And now , I have a query whose solution i want desperatly. I know if it had been solved before , but i didn't find it. My problem is , I have a created a database named wikiretail (OID=154086) in pgadmin-III and due to some reason , pgadmi