Postgres Pro
Downloads
Home   >   mailing lists

Thread: Backup problem

Backup problem

From
"Michael Schmidt"
Date:
I installed pgAdmin III 1.4b3 on Windows XP with PostgreSQL 8.0.4.  Startup and connection were uneventful.  However, when I tried to do a backup, I got the following error message.
 
Execution of command ' -i -h localhost -p 5432 -U postgres -F c -b -v -f "E:\Backup\pgadmin_test.backup" npcat_db' failed (error 2: the system cannot find the file specified.)
 
I know that libpq.dll and libintl-2.dll have been changed and tried the backup in two ways:  with version 8.0.4 and with version 8.1 in Windows/System32 directory.  Both methods resulted in the same error.
 
Thanks!
Michael Schmidt

Re: Backup problem

From
Andreas Pflug
Date:
Michael Schmidt wrote:
> I installed pgAdmin III 1.4b3 on Windows XP with PostgreSQL 8.0.4.  
> Startup and connection were uneventful.  However, when I tried to do a 
> backup, I got the following error message.
>  
> Execution of command ' -i -h localhost -p 5432 -U postgres -F c -b -v -f 
> "E:\Backup\pgadmin_test.backup" npcat_db' failed (error 2: the system 
> cannot find the file specified.)

This doesn't look like a msg from pgadmin. Post the whole text from 
pgAdmin's message tab.

Regards,
Andreas

Re: Backup problem

From
"Michael Schmidt"
Date:
The error message I posted came from the pgAdmin log.  The pgAdmin error message window states "An error has occurred: Execution of command ' -i -h localhost -p 5432 -U postgres -F -c -b -v -f"E:\Backup\test1.backup" npcat_db' failed (error 2: the system cannot find the file specified.)"
 
Michael Schmidt
----- Original Message -----
Sent: Sunday, October 23, 2005 4:08 AM
Subject: Re: [pgadmin-support] Backup problem

Michael Schmidt wrote:
> I installed pgAdmin III 1.4b3 on Windows XP with PostgreSQL 8.0.4. 
> Startup and connection were uneventful.  However, when I tried to do a
> backup, I got the following error message.
> 
> Execution of command ' -i -h localhost -p 5432 -U postgres -F c -b -v -f
> "E:\Backup\pgadmin_test.backup" npcat_db' failed (error 2: the system
> cannot find the file specified.)

This doesn't look like a msg from pgadmin. Post the whole text from
pgAdmin's message tab.

Regards,
Andreas

Re: Backup problem

From
"Dave Page"
Date:
 

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Michael Schmidt
Sent: 23 October 2005 16:21
To: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Backup problem

The error message I posted came from the pgAdmin log.  The pgAdmin error message window states "An error has occurred: Execution of command ' -i -h localhost -p 5432 -U postgres -F -c -b -v -f"E:\Backup\test1.backup" npcat_db' failed (error 2: the system cannot find the file specified.)"
 
Thanks Michael - I've committed a fix to make it actually find pg_dump/pg_restore correctly in the first place, and another to prevent the backup/restore options be made available if pg_dump/pg_restore really are missing.
 
Regards, Dave.

Re: Backup problem

From
"Derrick Betts"
Date:
I am having the same issue with backup and restore.  I have replaced the 
files on my Windows xp machine that is running pgAdmin III 1.4b3 with those 
dated 10-23 from the binary snapshot.  The postgres version is 8.0.4 runing 
on Linux.

Did I miss something else?

Thanks,
Derrick

----- Original Message ----- 
From: Dave Page
To: Michael Schmidt ; pgadmin-support@postgresql.org
Sent: Monday, October 24, 2005 7:10 AM
Subject: Re: [pgadmin-support] Backup problem



From: pgadmin-support-owner@postgresql.org 
[mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Michael Schmidt
Sent: 23 October 2005 16:21
To: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Backup problem


The error message I posted came from the pgAdmin log.  The pgAdmin error 
message window states "An error has occurred: Execution of command ' -i -h 
localhost -p 5432 -U postgres -F -c -b -v -f"E:\Backup\test1.backup" 
npcat_db' failed (error 2: the system cannot find the file specified.)"

Thanks Michael - I've committed a fix to make it actually find 
pg_dump/pg_restore correctly in the first place, and another to prevent the 
backup/restore options be made available if pg_dump/pg_restore really are 
missing.

Regards, Dave.

Re: Backup problem

From
Dave Page
Date:


On 27/10/05 12:57 am, "Derrick Betts" <derrick@grifflink.com> wrote:

> I am having the same issue with backup and restore.  I have replaced the
> files on my Windows xp machine that is running pgAdmin III 1.4b3 with those
> dated 10-23 from the binary snapshot.  The postgres version is 8.0.4 runing
> on Linux.
> 
> Did I miss something else?

That snapshot may have been produced before the fix was committed. Andreas
builds the win32 snapshots usually, and tends to do it when convenient for
him.

Regards, Dave