Re: [ADMIN] odbc - frontend HELP!!!

1999-05-27 Thread Jim Ridenour
I just went through the same problems you and Jim Burnett are describing. Here is what I got to work and how I did it. (Remember I am new to both Linux and Postgres so there may have been an easier way.) I am on a RH 5.0 system that installed Postgres from the RH cd. It puts Postgres 6.2

[ADMIN] Getting table structure from script

1999-05-27 Thread Àíäðåé Íîâèêîâ
Hello. Is there any way to get table structure from perl script (for instance using Pg). I need it very much, but now have to use copy/paste algorythm :) Andrey Novikov

Re: [ADMIN] Getting table structure from script

1999-05-27 Thread Jan Kim
On Thu, May 27, 1999 at 03:46:48PM +0400, @ mdpei Mnbhjnb wrote: > Is there any way to get table structure from perl script > (for instance using Pg). I need it very much, but now have > to use copy/paste algorythm :) Since I don't use Perl, I cannot offer a perl specific solution. General

Re: [ADMIN] Getting table structure from script

1999-05-27 Thread Oleg Bartunov
Hi, this is what I used some time ago. Don't know if it works now :-) Regards, Oleg #!/usr/bin/perl # Print information about database use Pg; $dbmain='mdb'; $conn = Pg::connectdb("dbname = $dbmain"); foreach ( keys (%conn) ) { print "$conn{$_}\n"; } $pghost=$

[ADMIN] updates failed, runaway postgres processes

1999-05-27 Thread Greg Wooledge
PostgreSQL 6.4.2, compiled and installed on AIX 4.3.2 (a PowerPC system). Everything was going fairly well until this morning. I noticed a problem when I tried to do a routine query on my database this morning -- it's a front-page CGI that I've run dozens of times over the last few days. There

[ADMIN] Postgres performance - Linux vs BSD

1999-05-27 Thread John C Cusick
We are planning to install a postgres database along with an apache webserver for a small internal Help-desk site. I have no intention of starting a OS war, but I have heard a great deal about FreeBSD being a superior network server relative to Linux, and I would like to know if there is some com

[ADMIN] Problem compiling 6.4.2

1999-05-27 Thread Jim Ridenour
Am running on a RedHat Linux 5.0 Intel box. Now have Postgres 6.2 running on it so I know it works. Have been trying to compile the new Postgres 6.4.2 with no success. The configure utility seems to run all right, but running gmake all >& make.log & as the doc's call for exits immediately wi

Re: [ADMIN] Problem compiling 6.4.2

1999-05-27 Thread Rich Shepard
On Thu, 27 May 1999, Jim Ridenour wrote: >Am running on a RedHat Linux 5.0 Intel box. Now have Postgres 6.2 > running on it so I know it works. Have been trying to compile the new > Postgres 6.4.2 with no success. The configure utility seems to run all > right, but running gmake all >& mak