Re: [ADMIN] Postgres server output log

2003-01-31 Thread Mintoo Lall
Thanks guys for the replies. I am using redhat linux 8.0 and postgres 7.2.3. I started my postgresql server with the following command after making the changes pg_ctl start -D /usr/local/pgsql/data -o "-i" If I understood correctly the syslog should have created a log file at /var/log/postgres

Re: [ADMIN] Making connections to postgres under FreeBSD

2003-01-31 Thread Sill-II, Stephen
I went back to 7.3.1 and everything is fine. I did start it with -i so it was listening. thanks for your help though. Steve -Original Message- From: Oliver Vecernik [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 4:28 PM To: Sill-II, Stephen Cc: Pgsql-Admin (E-mail) Subject:

Re: [ADMIN] Postgres server output log

2003-01-31 Thread Mintoo Lall
Thanks guys for the replies. I am using redhat linux 8.0 and postgres 7.2.3. I started my postgresql server with the following command after making the changes pg_ctl start -D /usr/local/pgsql/data -o "-i" If I understood correctly the syslog should have created a log file at /var/log/postgres

Re: [ADMIN] Making connections to postgres under FreeBSD

2003-01-31 Thread codeWarrior
Are you connecting on the "localhost" -- I saw no entry in your pg_hba.conf for localhost... Also -- Was postgres STARTED with -i or did you just change the pgoptions file and NOT restart your postgres server or reload the options file ??? pg_ctl RELOAD... ""Sill-II, Stephen"" <[EMAIL PROT

[ADMIN] pg_restore problem with 7.3.1

2003-01-31 Thread Ian Burrell
I am upgrading my PostgreSQL install from 7.2.3 to 7.3.1. I ran into a problem with pg_restore creating the database. I am not sure if this is a documentation problem or a real bug. I have one database with BLOBs and used tar format backup: "pg_dump -Ft -b mpmx > backup.tar". I saw the -C op

[ADMIN] COPY as non super user

2003-01-31 Thread Jaume Teixi
how should I use " COPY arti FROM 'ARTI.txt' USING DELIMITERS '|' " as normal user ? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can

Re: [ADMIN] COPY as non super user

2003-01-31 Thread Bruno Wolff III
On Fri, Jan 31, 2003 at 11:13:04 +0100, Jaume Teixi <[EMAIL PROTECTED]> wrote: > how should I use " COPY arti FROM 'ARTI.txt' USING DELIMITERS '|' " as normal user ? If you are using psql, use the \copy command. ---(end of broadcast)--- TIP 1: sub