[GENERAL] FW: Can't connect to instance with pgaccess

After several years away from Postgres, I'm back to using it for a small project. I installed 7.4.8 on a FreeBSD 5.4-STABLE machine. Then I init'd the db and added myself as a user, then created a ned db for the prohect. I can connect fine with psql. Then I built pgaccess, and p5-DBD-Pg-13 from

[GENERAL] Can't connect to instance with pgaccess

After several years away from Postgres, I'm back to using it for a small project. I installed 7.4.8 on a FreeBSD 5.4-STABLE machine. Then I init'd the db and added myself as a user, then created a ned db for the prohect. I can connect fine with psql. Then I built pgaccess, and p5-DBD-Pg-13 from t

[GENERAL] Measure the CPU Time per Transaction

Seems "explain" gives the run time, but not CPU time, right? I did not find such statistics in the Statistics Collector either. How to measure the CPU time per transaction in PostgreSQL? Thanks! Stan __ Do You Yahoo!? Tired of sp

[GENERAL] Clustering for performance and fail over

Hello all, I am interested in know if anyone has set up clustering for performance and fail over using PostgreSQL.  We are currently using Oracle for a distribution application and would like to use PostgreSQL with multiple application and database servers.    Regards Stan.Post your free ad now!

[GENERAL] Debian stable install problems

inate with semicolon to execute query \q to quit template1=# \q postgres@yogi:~$ /usr/local/pgsql/bin/createuser Enter name of user to add: stan Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y psql: connectDBStart()

[GENERAL] personel appliactions?

? I'm looking for. 1. CD/Music lirary management. 2. Library (books) management. 3. Household inventory/shoping list applications. 4. Calorie intake application. Any sugestions? -- Stan Brown [EMAIL PROTECTED]843-745-3154 Charleston SC. -- Windows

Re: [GENERAL] Web-based PSQL?

: > Stan Jacobs wrote: > > > is there a version of psql that runs via web interface? It seems like it > > would be rather trivial to build if it doesn't already exist, right? (And > > generally, at least to me, "trivial" means someone's already done i

[GENERAL] Web-based PSQL?

hi there, is there a version of psql that runs via web interface? It seems like it would be rather trivial to build if it doesn't already exist, right? (And generally, at least to me, "trivial" means someone's already done it. *smile*) Thanks, - Stan -

[GENERAL] limit on 'text' field?

es to look for more information, that would be great. thanks, -stan

Re: [GENERAL] How to retrieve table definition in SQL

x27;s an easy way to do this. On Sun, 19 Mar 2000, omid omoomi wrote: > Hi, > There are some system tables in any pg database which contain information > about table/field names/types and descriptions. use -e with psql command, > and look at the sql code when running /d command

[GENERAL] How to retrieve table definition in SQL

do that with the returned data. Thanks! - Stan -

[GENERAL] Simple problem?

Hi there, I must be confusing my syntax somehow, because I'm having trouble doing a simple update with returned id... As in I have two tables: an order table and an orderitems table. I need to write the order record, then use the order_id from the order record in the insert to the orderite

[GENERAL] INT4 on Linux/2.2.9 (x86)

int4 types corrupted or otherwise unavailable on this platform? Sorry if this is in a FAQ somewhere... If so, I'd greatly appreciate a pointer to the right direction. *smile* Thanks, - Stan -