Hi, Jeremy,
Have you tried PGadminIII? It's much easier to use.
To input a script, you can use psql
psql -h HOSTNAME -d DANAME -f FILENAME -U USERNAME
Changyu
--- jeremy ` <[EMAIL PROTECTED]> wrote:
> I am a bit of a newbie to postgres, but I managed to
> install 8.0.4 on my
> windows box and i
Hi Marco,
The problem I described in the first mail is that
because of some unknown reasons, if you save the
server.key file with a passphrase, you will be
prompted to enter the passphrase every time you start
the server AND a client make a connection, which
actually forbids us to use a passphrase
--- Marco Colombo <[EMAIL PROTECTED]> wrote:
> As long as the 'postgres' user has access to it w/o
> typing any password,
> that's only a detail. Unless someone physically
> steals your disk, the
> fact it's stored encrypted is irrelevant. The only
> thing that matters is
> who can access it, and
Hi Magnus,
You are right. My description is based on windows 2000
which is the weakest one.
Have the recovery key only available off-line is a
good practice. And if you don't want recovery agent,
backup the user's private key is also appropriate. It
can be done without effort. You don't need an arm
I don't know, I just tested it on win32.
Changyu
--- Magnus Hagander <[EMAIL PROTECTED]> wrote:
> (BTW, am I correct in reading this as a problem that
> only appears on
> win32, because of the exec nature of the backend,
> right? Or does it show
> up on Unix as well?)
>
> //Magnus
>
--- Marco Colombo <[EMAIL PROTECTED]> wrote:
> Either the Windows backup contains the private key
> of the user or not.
>
> If not, the backup is incomplete and useless (to get
> the file contents).
> You may get other files from it, but that's not the
> point. You may just
> not include the key
Hi,
Actually, if you've multiple installations of
postgreSQLs in different locations, you can start them
simultaneously. And for different clients to connect
to different server instances, you should change the
default port setting.
Changyu
--- Danny Gaethofs <[EMAIL PROTECTED]> wrote:
> Dear a
