Re: [ADMIN] pg_dump backup problems with password authentication

2000-12-07 Thread Ricardo Dias Marques
Hi again, I would like to thank Vasileiadis Spyros, Michael Ansley and Richard Poole who all pointed out the nature of the problem and the correct solution. SUMMARY The original situation was this: 1) I had changed authentication in pg_hba.conf from trust to password 2) This gave me a probl

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

[ADMIN] pg_dump backup problems with password authentication

2000-12-07 Thread Ricardo Dias Marques
Hi all, I am using PostgreSQL 7.0.2 in RedHat Linux 6.2 I have changed the default authentication, in the pg_hba.conf file, from trust to password. Unfortunately, this is giving me problems with pg_dump I am trying to do a copy of just one database (with all its tables, primary and foreign ke

[ADMIN] pg_ctl: Can't find :/usr/local/pgsql/data/postmaster.opts.default

2000-12-07 Thread Eduardo Kotujansky
I had to re-install postgresql in my FreeBSD machine. And after that I get an error: pg_ctl: Can't find :/usr/local/pgsql/data/postmaster.opts.default this file is ok with permissions to postgres user. what´s wrong here ?