Re: variable question with postgresql - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: variable question with postgresql
Date
Msg-id Pine.BSF.4.21.0102161120560.12587-100000@megazone23.bigpanda.com
Whole thread Raw
In response to variable question with postgresql  ("jeff kuo" <jhck81@hotmail.com>)
List pgsql-admin
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?



pgsql-admin by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: [GENERAL] what means "INSERT xxx yyy" ?
Next
From: Jreniz
Date:
Subject: PostgreSQL Benchmark!