Обсуждение: PGAdmin III v1.6.1 bug
PGAdmin III v1.6.1 binary install
Windows XP SP2 with all known patches
This was an issue in v1.4.2, as well.
I can backup a PostgreSQL v8.0.4 database with large objects with no problems. However, if I use PGAdminIII v1.6.1 to restore the database I receive an error message when pg_restore tries to restore the large objects and then the return code is set to 1. I have created a pgpass.conf file in the Application Data folder of the profile that I’m logged into when using PGAdminIII but that has no effect. If it’s supposed to then maybe I did something wrong. The way I successfully restore the database is to go into a command window on a different machine (Windows Server 2003 in this case) and run pg_restore from there. At the point where PGAdminIII fails, the command prompt version of pg_restore prompts for the password again.
I posted this issue before but I didn’t provide as much information because the problem is so easy to reproduce and because I was very busy at the time. If you need more information on how to reproduce the problem, please let me know.
Patrick Headley
Linx Consulting, Inc.
(303) 916-5522
LinxConsulting@comcast.net
www.linxco-inc.com
Patrick Headley wrote: > PGAdmin III v1.6.1 binary install > > Windows XP SP2 with all known patches > > > > This was an issue in v1.4.2, as well. > > > > I can backup a PostgreSQL v8.0.4 database with large objects with no > problems. However, if I use PGAdminIII v1.6.1 to restore the database I > receive an error message when pg_restore tries to restore the large > objects and then the return code is set to 1. I have created a > pgpass.conf file in the Application Data folder of the profile that I’m > logged into when using PGAdminIII but that has no effect. If it’s > supposed to then maybe I did something wrong. The way I successfully > restore the database is to go into a command window on a different > machine (Windows Server 2003 in this case) and run pg_restore from > there. At the point where PGAdminIII fails, the command prompt version > of pg_restore prompts for the password again. I cannot reproduce this here. What does your pg_hba.conf entry look like for the connection from your workstation? Can you provide a simple test case? Regards, Dave.