[GENERAL] Postmaster Won't Start

1998-08-01 Thread Bernie
whenever I attempt to start the postmaster, I get the following error: FindBackend: found "/usr/bin/postgres" using argv[0] FATAL: StreamServerPort: bind() failed: errno=13 Is another postmaster already running on that port? If not, remove socket node (/tmp/.s.PGSQL.)and retry.

[GENERAL] Weekly Posting: Mini-FAQ (Last Modified: Jun 7, 98)

1998-08-01 Thread The Hermit Hacker
Contains Sponsorship - Our Thanks Banner Ads Pointers to Recommended URLs Listing of Mailing Lists/Newsgroups Sponsorship - Our Thanks We (the Core Group) would like to thank the following companies and individuals for

Re: [GENERAL] PostgreSQL connect options?

1998-08-01 Thread Daniele Orlandi
Roland Roberts wrote: > > I'm actually looking to do this from PHP (in apache). So the function > I have is pg_connect, which is declared as > > int pg_connect(string host, string port, string options, >string tty, string dbname); > > So, I'm going to try stuffing the u

Re: [GENERAL] PostgreSQL connect options?

1998-08-01 Thread Roland Roberts
> "Maarten" == Maarten Boekhold <[EMAIL PROTECTED]> writes: Maarten> On Sat, 1 Aug 1998, Roland Roberts wrote: [...] Maarten> PQconnectdb("dbname=database user=username password=pwd Maarten> authtype=password"); This is more-or-less what I was looking for. Is there someplac

Re: [GENERAL] Autonumbering column

1998-08-01 Thread Antonio Garcia Mari
this is a hack, but it works... CREATE SEQUENCE key_s INCREMENT 1 START 1; CREATE TABLE cliente ( key int4 NOT NULL DEFAULT nextval('key_s') PRIMARY KEY, namevarchar(100) UNIQUE NOT NULL, usernamevarchar(8) NOT NULL ); > > > Hi, > > > > Is there

[GENERAL] PHP and keystone (formerly PTS)

1998-08-01 Thread Roland Roberts
This isn't exactly a PostgreSQL question, but... I've sent e-mail to [EMAIL PROTECTED], the author of Keystone, about what one needs to do to get Keystone to work with PostgreSQL. I have it almost working, and am wondering if anyone here has successfully used Keystone with PostgreSQL. What seem

[GENERAL] PostgreSQL connect options?

1998-08-01 Thread Roland Roberts
Once upon a time, I know I saw an example of using connect options to specify things like a user name. I can't find any examples in any of the references now. So what are some of the options and how does one specify them? roland -- Roland B. Roberts, PhD Custom Software Soluti