Re: What are the minimal files required to backup a postgresql database - Mailing list pgsql-general

From Craig Ringer
Subject Re: What are the minimal files required to backup a postgresql database
Date
Msg-id 4C164478.4090807@postnewspapers.com.au
Whole thread Raw
In response to Re: What are the minimal files required to backup a postgresql database  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
On 14/06/2010 9:14 PM, Alban Hertroys wrote:
> On 14 Jun 2010, at 14:20, Frank Church wrote:
>
>> I need to package the ability to backup a PostgreSQL database in my application?
>
> What are you trying to accomplish by that?
>
>> I obviously need to add pg_dump.exe to the package, and the dlls
>> required are listed below,
>
> You can check what dll's an executable depends on by using some MS tools. There's some documentation about that in
thepostgres wiki IIRC, look for debugging tools on windows. 

depends.exe from dependencywalker.com .

Basically, ship everything in the `bin' directory where pg_dump lives if
it's listed by depends.exe as used by pg_dump. Also make sure to provide
and silent-install the MSVC++ 2005 redist, which you can get from Microsoft.

Do *NOT* ship any system DLLs.

> Something to do with SSL apparently; you should only need that if you plan to use pg_dump over SSL.

That depends entirely on how DLL linkage is done. If it's an immediate
dependency rather than a delayed dependency, which it will be unless
configured otherwise, pg_dump will fail to load without that DLL even if
it's not going to use ssl.

I'm not on a Windows box with PG at the moment so I can't test.

--
Craig Ringer

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Is there a way to backup Postgres via SQL commands?
Next
From: Merlin Moncure
Date:
Subject: Re: Is there a way to backup Postgres via SQL commands?