variable question with postgresql

Поиск
Список
Период
Сортировка
Искать

variable question with postgresql

От:
"jeff kuo" <jhck81@hotmail.com>
Дата:
hi, all
I am using phpPgAdmin to create tables and fields, and how do I use SET variables to defind a title, eg. Mr. Miss. Mrs.
 
Another question, when I use the pg_connect("localhost","","","","dbname"); to connect to a the database, the server returns this message
 
Unable to connect to PostgreSQL server: connectDB() -- connect() failed: Connection refused Is the postmaster running (with -i) at 'localhost' and accepting connections on TCP/IP port '5432'?
 
and when I chage to pg_connect("","","","","dbname");
return this message
Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'www-data' is not in 'pg_shadow'
 
can anyone please tell me why !? thank you very much
 
Jeff K.
 


Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Re: variable question with postgresql

От:
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Дата:
On Thu, 15 Feb 2001, jeff kuo wrote:

> hi, all
> I am using phpPgAdmin to create tables and fields, and how do I use SET variables to defind a title, eg. Mr. Miss. Mrs.
>  
> Another question, when I use the pg_connect("localhost","","","","dbname"); to connect to a the database, the server returns
> this message
>  
> Unable to connect to PostgreSQL server: connectDB() -- connect() failed: Connection refused Is the postmaster running (with
> -i) at 'localhost' and accepting connections on TCP/IP port '5432'?

Okay, this probably means you didn't start the server with -i so it's only 
accepting local unix domain socket connections.

> and when I chage to pg_connect("","","","","dbname");
> return this message
> Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'www-data' is not in 'pg_shadow'

Have you created a database user www-data?


FAQ