Enrico Ortmann <pg(dot)admin(at)radax(dot)net> writes:
> But when I connect using the IP-adress instead of the alias
> $conn = @pg_pconnect("host=192.168.0.200 port=5432 user=postgres dbname=template1");
> the handle is valid as well, but then if I want to create the database I got the error
> ERROR: CREATE DATABASE: source database "template1" is being accessed by other users
> Does anybody have an idea what goes wrong in case I use the IP?
This message has nothing to do with how you connect. I suspect you
forgot to disconnect the other connection.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2004-01-16 15:55:50|
|Subject: Re: Protect pg_xlog ? |
|Previous:||From: Jeff||Date: 2004-01-16 14:54:29|
|Subject: Re: Snapshot as Backup|