[ADMIN] Can not connect to database in Workgroup-Net on Windows-XP

2007-01-11 Thread Josef Springer
Title: Signature Hi folks, i have a workgroup (not a classic server)  with Windows-XP-machines: the database server machine contains the line host    all    all    0.0.0.0    0.0.0.0    md5 in the file pg_hba.conf and listen_addresses = '*'  in the f

Re: [ADMIN] Can not connect to database in Workgroup-Net on Windows-XP

2007-01-11 Thread Andy Shellam (Mailing Lists)
Firstly it would be helpful to say what error you're getting on the client side. At a quick guess, I would say it's because you've got 2 "0.0.0.0" declarations in your pg_hba.conf - you only need the one - like this: hostall all 0.0.0.0/0 md5 Regards, Andy. Josef Springer w

Re: [ADMIN] Lob datatype

2007-01-11 Thread Rigmor Ukuhe
Alexander Burbello wrote: Hi people, I was reading the documentation about PG, but I didn't find out what the Lob datatype to store images, etc. And what's the limitation to user that. I have used bytea Rigmor Could you help me? Thank you. Alexander __

[ADMIN] configuring the postmaster.log

2007-01-11 Thread Marc Mamin
Hello, I'm confused about the logging destination parameters in postgresql.conf My Problem is that the postmaster.log is getting too large and I want to roll it (once per day) Following parameters apply to optional postgresql...log. log_rotation_age = 1440 log_filename = 'postgresql-%Y-%

Re: [ADMIN] configuring the postmaster.log

2007-01-11 Thread Andy Shellam (Mailing Lists)
Marc Mamin wrote: Hello, I'm confused about the logging destination parameters in postgresql.conf My Problem is that the postmaster.log is getting too large and I want to roll it (once per day) Following parameters apply to optional postgresql...log. log_rotation_age = 1440 log_fil

Re: [ADMIN] Can not connect to database in Workgroup-Net on Windows-XP

2007-01-11 Thread Josef Springer
Hi Andi, i get an error message "Can not connect to database..." or similar. I will ask the customer. The system at another customer runs with hostall all 0.0.0.0/0 md5 Josef Andy Shellam (Mailing Lists) wrote: Firstly it would be helpful to say what error you're getting

Re: [ADMIN] configuring the postmaster.log

2007-01-11 Thread Marc Mamin
Sorry , my mistake: The "postmaster.log" that I mentioned is defined in our Postgres start script: startproc -u <@DB_USER@> $PGSQL_BIN -D <@INSTALL_DIR@>/postgresql-data \ >> <@INSTALL_DIR@>/postgresql/postmaster.log 2>&1 Marc ---(end of broadcast)-

[ADMIN] Please help

2007-01-11 Thread raphael ferrer
Hello, I would like to stop receive emails from pg forum. How could i do that? Thanks _ Die MSN Homepage liefert Ihnen alle Infos zu Ihren Lieblingsthemen. http://ch.msn.com/ ---(end of broadcast)--

Re: [ADMIN] Please help

2007-01-11 Thread Adam Witney
You can unsubscribe here http://www.postgresql.org/community/lists/subscribe On 11/1/07 14:05, in article [EMAIL PROTECTED], ""raphael ferrer"" <[EMAIL PROTECTED]> wrote: > Hello, > > I would like to stop receive emails from pg forum. > > How could i do that? > > Thanks > > ___

Re: [ADMIN] Can not connect to database in Workgroup-Net on Windows-XP

2007-01-11 Thread Josef Springer
Hi Andy, here ist the error mesage trying to connect: "Zum Server ist keine Verbindung möglich, oder Login/Passwort sind falsch. Die Anmeldung wurde abgelehnt." Josef Andy Shellam (Mailing Lists) wrote: Firstly it would be helpful to say what error you're getting on the client side. At a

Re: [ADMIN] configuring the postmaster.log

2007-01-11 Thread Tom Lane
"Marc Mamin" <[EMAIL PROTECTED]> writes: > Sorry , my mistake: > The "postmaster.log" that I mentioned is defined in our Postgres start > script: > startproc -u <@DB_USER@> $PGSQL_BIN -D <@INSTALL_DIR@>/postgresql-data \ > <@INSTALL_DIR@>/postgresql/postmaster.log 2>&1 That file will be used unti

[ADMIN] Invalid Checksum in Control File

2007-01-11 Thread Christopher Bland
We recently had a system failure and needed to rebuild a server. Our database is stored in a storage array and after the rebuild my service fails with pglog reporting: FATAL: incorrect checksum in control file I've read that the control file is saved in pg_clog however I have not been able to fi

Re: [ADMIN] Invalid Checksum in Control File

2007-01-11 Thread Tom Lane
"Christopher Bland" <[EMAIL PROTECTED]> writes: > FATAL: incorrect checksum in control file Does pg_controldata print anything useful? regards, tom lane ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [ADMIN] What library uses postmaster when lib postgres files

2007-01-11 Thread Adam Radlowski
I checked the libraries used by pg_ctl and postmaster. They use proper libs without use LD_LIBRARY_PATH, but I used it "for safety" in the postmaster starting script. One more big thanks. Adam Jorge Serván wrote: The Libraries used are solved by the liker. Try ldd to show the paths of the li