Обсуждение: Restore/Backup menu items missing
I have just installed PostgreSQL 10.5 and PGAdmin 3 on a Windows Server 2012 machine.
I have created a database via PGAdmin and I now want to load this database from a backup. However, when I right click on the database object the Backup and Restore menu items do not appear.
I have the same version of PGAdmin 3 on a Windows 7 machine and it works fine.
Pg_restore.exe and pg_dump.exe are in the bin folder.
Thanks
Mark
__
On 19/10/18 12:44, Mark Williams wrote: > I have just installed PostgreSQL 10.5 and PGAdmin 3 on a Windows Server > 2012 machine. > > I have created a database via PGAdmin and I now want to load this > database from a backup. However, when I right click on the database > object the Backup and Restore menu items do not appear. > > I have the same version of PGAdmin 3 on a Windows 7 machine and it works > fine. > > Pg_restore.exe and pg_dump.exe are in the bin folder. Just a guess, but you may have to tell pgAdmin where pg_dump and pg_restore are - look in the options. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
Spot on. Thanks. The binary paths folder in File + Options was not set. On the previous install it seems to have been automatically set. __ -----Original Message----- From: Raymond O'Donnell <rod@iol.ie> Sent: 19 October 2018 12:54 To: Mark Williams <markwillimas@gmail.com>; pgadmin-support@lists.postgresql.org Subject: Re: Restore/Backup menu items missing On 19/10/18 12:44, Mark Williams wrote: > I have just installed PostgreSQL 10.5 and PGAdmin 3 on a Windows > Server > 2012 machine. > > I have created a database via PGAdmin and I now want to load this > database from a backup. However, when I right click on the database > object the Backup and Restore menu items do not appear. > > I have the same version of PGAdmin 3 on a Windows 7 machine and it > works fine. > > Pg_restore.exe and pg_dump.exe are in the bin folder. Just a guess, but you may have to tell pgAdmin where pg_dump and pg_restore are - look in the options. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie