|
|
 | | From: | John DeSoi | | Subject: | Re: | | Date: | Fri, 21 Jan 2005 02:19:10 -0500 |
|
|
 |
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.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
|
|
| | From: | Sean Davis | | Subject: | Re: | | Date: | Fri, 21 Jan 2005 06:11:28 -0500 |
|
|
|
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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
|
|
|
