Re: [ADMIN] Standalone Hot Backups

2013-08-21 Thread Richard Poole
porarily; the last command in the sequence adds the files from the temporary archive to the base backup in the tar file. So you don't actually need the pg_xlog directory and it would be OK for the base backup to have excluded it. Short answer: it is OK to omit pg_xlog, because as part of a s

Re: [ADMIN] Type Conversion Error after migrating from 8.3 to 9.2

2013-05-13 Thread Richard Poole
On Mon, May 13, 2013 at 04:34:14PM +0530, Hariraman Jayaraj wrote: > But in some inserts where we use like > *to_timestamp('8-5-2013 22:00:02','dd-mm- hh:mi:ss')::TIMESTAMP* > it throws error as > hour "22" is invalid for the 12-hour clock. The 'hh' pattern has always been documented as meani

Re: [ADMIN] Trouble Escaping Quotes

2005-01-23 Thread Richard Poole
On Fri, Jan 21, 2005 at 08:43:00AM -0700, Haron, Charles wrote: > Yes, but how do you escape the quote when the value of the string isn't know > until the function is run? > > If $rma_data->{\'company_name\'} is returning Bob's Fixit at run time, how > do escape the quote BEFORE Perl interprets t

Re: [ADMIN] Forgot admin pw on initialization/install RH 7.3/PGSQL7.2

2002-05-24 Thread Richard Poole
On Thu, May 23, 2002 at 11:20:27PM -0400, Jeff Kowalczyk wrote: > I made a dumb mistake, and forgot to write down the autogenerated > administrator password when I first started the Postgres database on > RedHat 7.3. I'm having a hard time finding information on how to do this > online, and it's a

Re: [ADMIN] pg_dump backup problems with password authentication

2000-12-07 Thread Richard Poole
On Thu, Dec 07, 2000 at 01:07:17PM +, Ricardo Dias Marques wrote: > So, I did a man pg_dump and found out that -u would prompt > for username and password, and -v would give a verbose output. > And so I did: > pg_dump -u -v dbname > dbname.pgdump > > > The problem is when I press the ENTER