[ADMIN] pg_dump restore problem

2003-03-30 Thread Devi Munandar
Hi admin i have problem with user authentification I've made a dump from PostgreSQL 7.2.2 under linux 8.0 with the command: pg_dump -a -b -Fc -f bakstore -o -v store and running success, and then i try to restore with the command: pg_restore -a -d store -Fc -o -v bakstrore and running unsucces

Re: [ADMIN] pg_dump restore problem

2003-03-30 Thread Peter Eisentraut
Devi Munandar writes: > MAPIDENTPGUSERNAME > phpuserphpuserpostgres With this setup you can connect if your OS user is "phpuser" and the user you want to connect as is "postgres". So log in as "phpuser" on you OS and run pg_restore with the option -U p

[ADMIN] pgAdmin II questions

2003-03-30 Thread Tamir Halperin
I just finished upgrading from FreeBSD 4.6 to 4.8RC and I'm trying to do some things with pgAdmin II which are giving me problems. I remember creating a db called taxcal and it's listed there. However, I don't remember creating a db called pgsql. Is this a db that the postgresql needs or was it