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
>> 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
>> database. What is the easiest way to this? What I am thinking of
>> 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.
In response to
- Re: at 2005-01-21 07:19:10 from John DeSoi
pgsql-novice by date
|Next:||From: Sean Davis||Date: 2005-01-21 11:14:37|
|Subject: Re: grant all the database object automatically|
|Previous:||From: Sean Davis||Date: 2005-01-21 11:08:46|
|Subject: Re: hoe to connect postgres database thru perl|