Re: [ADMIN] Invalid User ID: 0

2004-07-20 Thread Howard Bagcat
> What account is the postmaster service running under? Postgres or someother account? Not postgres but a different account. The same username used during the "initdb" process. As for your information, the said account/username can get into any of my local database without problems. Only yester

Re: [ADMIN] Invalid User ID: 0

2004-07-20 Thread Mike G
What account is the postmaster service running under? Postgres or someother account? What version of postgres and windows is this running on? Mike On Wed, Jul 21, 2004 at 09:14:05AM +0800, Howard Bagcat wrote: > Anyone, > > I am troubled on logging on to my postgresql running under Cygwin. Post

Re: [ADMIN] [HACKERS] Point in Time Recovery

2004-07-20 Thread Gaetano Mendola
Simon Riggs wrote: On Wed, 2004-07-14 at 03:31, Christopher Kings-Lynne wrote: Can you give us some suggestions of what kind of stuff to test? Is there a way we can artificially kill the backend in all sorts of nasty spots to see if recovery works? Does kill -9 simulate a 'power off'? I was h

Re: [ADMIN] Logging PostgreSQL output

2004-07-20 Thread Gaetano Mendola
Joost Kraaijeveld wrote: Hi all, I want to log all PostgreSQL's output in a seperate file. Is it possible to use the syslog system to do that or is the only way to use the stdout method? If it is possible to use the syslog system, how should I do this (I have tried several things but nothing I trie

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-20 Thread Gaetano Mendola
Christopher Browne wrote: After a long battle with technology, [EMAIL PROTECTED] ("Matt Browne"), an earthling, wrote: I apologise in advance if any of my questions are in a FAQ somewhere - I haven't seen them... Does anyone know when (if ever) replication support will be added to the main Postgre

[ADMIN] execute user-defined BKI

2004-07-20 Thread Howard Bagcat
Anyone, How can I execute my BKI script? Kumusta, Howard E-Sulat v.0.0.1 ( Manna ) ... An extended module for MUWeb4 Project Powered by Horde, Postfix, PostgreSQL & Courier-IMAP

[ADMIN] Invalid User ID: 0

2004-07-20 Thread Howard Bagcat
Anyone, I am troubled on logging on to my postgresql running under Cygwin. Postmaster says, "Fatal: Invalid User ID 0" after connecting. I know for sure that the username that I am using to log is existing. Thinking that having a new user will solve the problem, I tried creating a new user but s

[ADMIN] unsubscribe

2004-07-20 Thread Daniel Caixeta Barroso
unsubscribe-digest pgsql-admin ___ Yahoo! Mail agora com 100MB, anti-spam e antivírus grátis! http://br.info.mail.yahoo.com/ ---(end of broadcast)--- TIP 5: Hav

Re: [ADMIN] Large file support needed? Trying to identify root of

2004-07-20 Thread Kris Kiger
Thanks Tom, -Fc worked great! I appreciate your help. Kris Tom Lane wrote: Kris Kiger <[EMAIL PROTECTED]> writes: I've got a database that is a single table with 5 integers, a timestamp with time zone, and a boolean. The table is 170 million rows in length. The contents of the tar'd dump fil

[ADMIN] Error in logfile on DB startup

2004-07-20 Thread Nigel Bishop
Hi Solaris 8, PG 7.4.2 installed from source The DB appears to be running OK I set the following in the pg_conf file to invoke statistics gathering: stats_start_collector = true stats_block_level = true In the logfile after the DB was re-started the following appeared: 2004-07-19 16:25:12 LOG