From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | John DeSoi <desoi(at)pgedit(dot)com> |
Cc: | karim(at)zeecore(dot)net, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2005-01-21 11:11:28 |
Message-ID: | 326FFA71-6B9D-11D9-91D9-000D933565E8@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2005-01-21 11:14:37 | Re: grant all the database object automatically |
Previous Message | Sean Davis | 2005-01-21 11:08:46 | Re: hoe to connect postgres database thru perl |