Skip site navigation (1) Skip section navigation (2)

Re:

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 (view raw or flat)
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


In response to

  • Re: at 2005-01-21 07:19:10 from John DeSoi

pgsql-novice by date

Next:From: Sean DavisDate: 2005-01-21 11:14:37
Subject: Re: grant all the database object automatically
Previous:From: Sean DavisDate: 2005-01-21 11:08:46
Subject: Re: hoe to connect postgres database thru perl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group