Re:

On Jan 21, 2005, at 2:19 AM, John DeSoi wrote:

>
> On Jan 19, 2005, at 7:10 AM, Karim Mardhani wrote:
>
>>   1.  How do I programmatically call backup (pg_dump) and vacuum?  I
>> am
>> using .NET provider as the interface to the postgreSql.  I didn't see
>> any provision in the .Net provider to invoke these commands.  Does
>> postgresql support SQL's "BACKUP" and "RESTORE" commands?
>
> I'm not familiar with .net, but I would guess there is a way to
> execute command line programs? So you would have to know the location
> of the PostgreSQL bin directory (which should be in the registry from
> the install) and then call the pg_dump.exe binary. Vacuum is a normal
> SQL command which you could call using psql and the -c option.
>
>>
>>   2.  As part of installation I would like to create and populate a
>> new
>> database.  What is the easiest way to this?  What I am thinking of
>> doing
>> is to install psql client program and using it to create database.  Is
>> there any way I don't have to install psql on every client's machine?
>>
>
> Same approach as above using initdb.exe and createdb.exe utilities. Or
> psql would work as long as you already have a cluster setup.

I would add that pgadminIII is a very nice way to interact with the
database and probably deserves a look.  You could install that on the
other machines, rather than psql.

Sean