Re: Crash: backup / restore

Le 19/10/2010 13:24, Anssi Kääriäinen a écrit :
> PGAdmin hangs when dumping / restoring a database. I can get to the
> screen that has the pg_dump / pg_restore command, but after that screen
> is displayed there is no progress, and only thing I can do is kill the
> program. (the file dumped to is created but it is empty).
>
> I thing the bug is related to my pg_hba.conf, relevant lines:
>
> local all all trust
> host all all 127.0.0.1/32 trust
> host all all xxx.zzz.0.0/16 md5
>
> I use user "akaariai" which has no password and which is both database
> superuser and my local linux user.
>
> My PGAdmin connection is set up as follows:
> name: localhost
> host: localhost
> port: 5432
> maintenance_db: postgres
> username: akaariai
> store password checked, restore_env checked. Nothing else set, that
> means also no password set. I can open the connection without any errors.
>
> The command PGAdmin is trying to run when backup is requested:
> pg_dump --host localhost --port 5432 --username akaariai --format ...
>
> If I run the command manually, the command asks for password. If I run
> the command without "--host localhost", there is no password prompt.
> Could it be that PGAdmin doesn't expect the server to ask password?
>

There is no communication between pgAdmin and pg_dump. If pg_dump needs
to ask for a password, you'll surely have your pgAdmin completely blocked.

> Also, if I remove the host=localhost from pgadmin connection
> configuration (leaving host blank), I can backup any DB without errors.
>

From pgAdmin, I suppose?

> I am using ubuntu 10.04, apt installed postgresql 8.4.5, apt installed
> pgAdmin, version: 1.10.2 rev 8217.
>

pgAdmin cannot give the password to pg_dump without using the
environment variable (PGPASSWORD)... but it means the password will
appear in the ps output. That won't happen. The only workaround
available is to use a .pgpass file. Which pgAdmin would have created if
you allowed it to store the password.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com