[ADMIN] pg_dump question...

2000-01-29 Thread Brad Bonkoski
Hello.. I have password authentication going on my DB, and everything works quite well except for this command: pg_dump -u > dumpfile it just hangs but when I run pg_dump -u it will print all the stuff out to me, so I assume it must be with putting it into a file. Does anyone have any sug

[ADMIN] request for tuning suggestions from PC Week Labs

2000-01-29 Thread Timothy Dyck
Hi all, I'm the database analyst for PC Week Labs and am comparing PostgreSQL with Inprise's InterBase (which will be open sourced later this year). As part of this project, I'm running a benchmark with a mix of OLTP and DSS queries in a set of various mixes and at a variety of user loads (up t

Re: [ADMIN] migrating administrative pieces to new install

2000-01-29 Thread Peter Eisentraut
On 2000-01-28, hal Lynch mentioned: > All databases are read(select) only. my pg_hba.conf looks like this: > local all password passwd. > > pg_dumpall fails. I haven't found a way to supply a username > and password to the command. The -u flag dosen't work. That's right. Since every data