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