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
--- 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
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
>
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
--- 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 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
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
