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

Re: can't create db from PHP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Enrico Ortmann <pg(dot)admin(at)radax(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: can't create db from PHP
Date: 2004-01-16 15:47:42
Message-ID: 29946.1074268062@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
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 LaneDate: 2004-01-16 15:55:50
Subject: Re: Protect pg_xlog ?
Previous:From: JeffDate: 2004-01-16 14:54:29
Subject: Re: Snapshot as Backup

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