Re: [ADMIN] recovering using a continuous archive backup doesn'twork on Windows

2007-04-05 Thread Sabin Coanda
Hi, Finally I solved it. It was just a rights access problem. When I save/copy/move/cleanup the data directory, I used my account, and postgres user had no rights to write/modify the new data directories. I give it rights and the recovery works well now. Regards, Sabin BTW: Although the right

[ADMIN] Advice on migration without down-time

2007-04-05 Thread Gabriele Bartolini
Hi guys, due to the wrong initialisation of PostgreSQL data dir (which generates 'invalid multibyte character for locale'), I need to migrate approximately a 90GB database system on PostgreSQL 8.2.3. There is no replication system set up, yet. The rawest solution is to: - stop the server

Re: [ADMIN] xlog related error

2007-04-05 Thread Bellur Ashwin
--- Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote: > On 4/5/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> > writes: > > > A friend of mine getting following error > > > > > Error: xlog flush request 0/797FED50/ is not > satisfied -- flushed only > > > to 0/

[ADMIN] information about postgresql

2007-04-05 Thread sufian khan
Dear I want to know about POSRGRESQL in full detail. What is its memory structure and others backgrounds process, datafiles, controlfile? How it works? Complete picture of Postgresql Database. Like ORACLE SERVER. Regards Muhammad Sufian Khan Functional Consultant – Kohinoor

Re: [ADMIN] autovacuum question

2007-04-05 Thread Thomas Pundt
On Wednesday 04 April 2007 20:40, Carol Walter wrote: | Hi, I'm looking in my log file with today's date. I'm using VIM and | have done a search for a pattern match on "autovac", "vacuum", and | "auto" VIM returned "string not found" for each search. Am I | looking for the wrong string, or is t