[ADMIN] Fast CGI

2002-05-02 Thread Aaron Spiteri
Title: Fast CGI Hi all, Does any one know a method of creating a persistent connection to postgresql using PERL DBI::Pg and Apache, I have been experimenting with CGI::Fast and use compiled Fcgi module into Apache. While all seemed fine when I checked the connection of postgres using a ps -x

[ADMIN] ALTER TABLE for field modify...

2002-05-02 Thread MG
Hi! How can I modify a field of table with ALTER TABLE? I want to modify the constraint. The TABLE is now: "ID"int8NOT NULL, UNIQUE But I want this: "ID" int8 REFERENCE "table2" THanx! Bye! - Linux RedHat 7.1 - ---(end of

[ADMIN] Authentication in batch processing

2002-05-02 Thread Hal Lynch
I have postgres set up to require usernames and passwords for access. The following script works just fine in 7.1.2 without manual intervention. Using 7.2.1 psql issues a password prompt and blocks until a password is manually entered. ### #!/bin/sh psql myd

[ADMIN] which replication?

2002-05-02 Thread Judy Jecelin
I am confusedthere seem to be a number of replication "options" with PostgreSQL and I'm not sure if they are all the same or if one is better, or which one to use! There's Rserv, PGReplicator, eRserver, Usogres, and maybe one otherHelp! I'm confused! We've got PostgreSQL 7.1.3 and 7

Re: [ADMIN] ALTER TABLE hangs

2002-05-02 Thread Stephan Szabo
On Thu, 2 May 2002, Mike Baker wrote: > > > > Hi. > > > > > > I am in the process of doing some data migration. > > I > > > have had no trouble moving my data, but am having > > > problems creating a foreign key. > > > > > > When I run the following command, psql hangs > > (well, > > > not totall

Re: [ADMIN] ALTER TABLE hangs

2002-05-02 Thread Mike Baker
> > Hi. > > > > I am in the process of doing some data migration. > I > > have had no trouble moving my data, but am having > > problems creating a foreign key. > > > > When I run the following command, psql hangs > (well, > > not totally sure if it is hung). > > It probably isn't hung, but it'

[ADMIN] Process balancing on smp db server/apache web server

2002-05-02 Thread Peter Darley
Friends, I have been thinking about my smp db server and how it interacts with my web server. I'm using mod_perl on Apache, which uses Apache::DBI to connect to the db server via a private network segment. It occurs to me that since the web server is connecting early (on startup), when t

[ADMIN] unsubscribe

2002-05-02 Thread Judy Jecelin
__ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] HOWTO - Random character generation for primary key

2002-05-02 Thread Jean-Michel POURE
Le Jeudi 2 Mai 2002 04:01, Alan Wayne a écrit : > In foxpro, I've been using the provided 10-character > random generator to provide for the primary keys on my > data files. As far as I can tell, PostgreSQL only uses > an auto-incrementing serial field for its primary > keys. So as far as I can se