Thread: variable question with postgresql
<div><div><div>hi, all</div><div>I am using phpPgAdmin to create tables and fields, and how do I use SET variables to definda title, eg. Mr. Miss. Mrs.</div><div> </div><div>Another question, when I use the pg_connect("localhost","","","","dbname");to connect to a the database, the server returns this message </div><div> </div><div>Unableto connect to PostgreSQL server: connectDB() -- connect() failed: Connection refused Is thepostmaster running (with -i) at 'localhost' and accepting connections on TCP/IP port '5432'? </div><div> </div><div>andwhen I chage to pg_connect("","","","","dbname");</div><div>return this message</div><div>Unableto connect to PostgreSQL server: FATAL 1: SetUserId: user 'www-data' is not in 'pg_shadow' </div><div> </div><div>can anyoneplease tell me why !? thank you very much</div><div> </div><div>Jeff K.</div><div> </div></div></div><brclear="all" /><hr />Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a>.<br/>
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?