Re: [ADMIN] 7.4.1 binary for RH9?

2004-06-07 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 23 Feb 2004, Kris Chapman wrote: I want to install 7.4.1 using an rpm, but I can't seem to find a binary for RH9. Try installing the rpms built for RHEL3, under /binary/v7.4.1/redhat/rhel3. They'll work on RH 9. Regards, - --

Re: [ADMIN] Java Applet + Postgre SQL

2004-06-07 Thread Jouneau Luc
Hi, you should give access to postgresql jdbc driver (http://jdbc.postgresql.org) from your applet and afterwards look at http://doc.postgresintl.com/jdbc/index.html to find what you need. - Luc Jouneau Unité Centrale Informatique de Jouy, INRA Domaine de Vilvert 78352 Jouy

[ADMIN] Cannot built PL/Tcl because Tcl is not a shared library; skipping it

2004-06-07 Thread lise chhay
For tcl, I've run ./configure --enable-shared to have a tcl like a shared library and for tk, I've run ./configure --enable-shared --with-tcl to have a tk like a shared library. The installation of tcl and of tk work fine. For postgreSQL, I've run ./configure --with-tclconfig --with-tkconfig

Re: [ADMIN]

2004-06-07 Thread scott.marlowe
On Mon, 23 Feb 2004 [EMAIL PROTECTED] wrote: Hi, We are running Postgresql 7.3.4. Does anyone know how to make pg_dump write dumps larger than 2 GB?? Compilation with D_FILE_OFFSET_BITS=64 gave no results... Hi, what OS and such are you running on? I've had no problems on RH7.2

[ADMIN] Cannot built PL/Tcl because Tcl is not a shared library; skipping it

2004-06-07 Thread lise chhay
For tcl, I've run ./configure --enable-shared to have a tcl like a shared library and for tk, I've run ./configure --enable-shared --with-tcl to have a tk like a shared library. The installation of tcl and of tk work fine. For postgreSQL, I've run ./configure --with-tclconfig

[ADMIN] Where can I find PostgreSQL for Solaris SPARC and x86 platforms?

2004-06-07 Thread Christopher Smiga
Where can I find PostgreSQL for Solaris SPARC and x86 platforms? -- Christopher Smiga System Engineer (Sun SCSA) N2 Broadband Network Operations Phone: 678-812-6353 (Desk) Phone: 888-671-1268 (NOC) Fax:678-812-6453 e-Mail: [EMAIL PROTECTED] - N2 Broadband, Inc. (www.n2bb.com) 4500 River

Re: [ADMIN] Cannot built PL/Tcl because Tcl is not a shared library; skipping it

2004-06-07 Thread Tom Lane
lise chhay [EMAIL PROTECTED] writes: For tcl, I've run ./configure --enable-shared to have a tcl like a shared library and for tk, I've run ./configure --enable-shared --with-tcl to have a tk like a shared library. The installation of tcl and of tk work fine. For postgreSQL, I've

[ADMIN] Mac OS 10.3.4: pgsql fails to launch at boot

2004-06-07 Thread Randall Perry
On searching the archives I noticed Bob Smith in Jul, 2002 had a similar problem to mine, but never posted a solution. I'm using pgsql 7.4.2 on Mac OS 10.3.4. I installed the startup script for darwin from the contrib/start-scripts folder. On boot, pgsql startup fails and I see this error in the

[ADMIN] How to export users?

2004-06-07 Thread Chris Hoover
I am having a bit of a problem with getting my users to a new server. Does anyone know a quck way to export the user list from one server to import into a new server? Thanks, Chris ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [ADMIN] Mac OS 10.3.4: pgsql fails to launch at boot

2004-06-07 Thread Jeff Self
On Mon, 2004-06-07 at 10:28, Randall Perry wrote: On searching the archives I noticed Bob Smith in Jul, 2002 had a similar problem to mine, but never posted a solution. I'm using pgsql 7.4.2 on Mac OS 10.3.4. I installed the startup script for darwin from the contrib/start-scripts folder. On

Re: [ADMIN] How to export users?

2004-06-07 Thread Marc Mitchell
Try pg_dumpall -g. See http://www.postgresql.org/docs/7.4/interactive/app-pg-dumpall.html Good luck. Marc Mitchell - Transportation Practice Director Enterprise Information Solutions Downers Grove, IL 60515 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

[ADMIN] Growing number of postmaster processes

2004-06-07 Thread Marek Dbrowski
Hello I have installed postgres 7.4.2. During normal working of my serwer number of postmaster processes are from 1 to 60. When I have set on log_statement_stats=true then numer of processes quickly growing up to limit allowed connection and serwer dont response. Guys do you know what is going

Re: [ADMIN] Mac OS 10.3.4: pgsql fails to launch at boot

2004-06-07 Thread Randall Perry
on 6/7/04 12:57 PM, Jeff Self at [EMAIL PROTECTED] wrote: On Mon, 2004-06-07 at 10:28, Randall Perry wrote: On searching the archives I noticed Bob Smith in Jul, 2002 had a similar problem to mine, but never posted a solution. I'm using pgsql 7.4.2 on Mac OS 10.3.4. I installed the startup

Re: [ADMIN] Mac OS 10.3.4: pgsql fails to launch at boot

2004-06-07 Thread Jose' Cruanyes
probably the scripts kicks in too early because the StartupParameters.plist file is not correct here's mine --- { Description = PostGreSQL RDBMS; Provides = (PostGreSQL); Requires = (Network, Resolver); Uses = (Network Time, NFS);

[ADMIN] force connection timeout

2004-06-07 Thread Ben Kim
I'd like to know if it's possible to force connection timeout on idle connections. I have Apache connecting to the PostgreSQL through DBI connection, and sometimes the connections are used up and I can't get a new connection. We reasonably made sure we close the connections on each page, but

[ADMIN] Syntax question

2004-06-07 Thread Jeff Stout
I am fairly new to postgres, I need to know how to switch databases once I'm in a psql session. I can't seem to find the command for \h , maybe I just blind |-; Thank you in advance Jeff Stout ---(end of broadcast)--- TIP 9: the planner will

Re: [ADMIN] Syntax question

2004-06-07 Thread Scott Marlowe
On Mon, 2004-06-07 at 15:18, Jeff Stout wrote: I am fairly new to postgres, I need to know how to switch databases once I'm in a psql session. I can't seem to find the command for \h , maybe I just blind |-; \c database ---(end of broadcast)---

Re: [ADMIN] E-R Tool

2004-06-07 Thread Jaime Casanova
Hello, Db-designer is a nice tool, can work with importing Oracle databases, and use it with PG and MySQL. Hope this helps BR, Miguel Can someone suggest an E-R tool that will read a _PG_ database and create an E-R diagram - crows feet and all? Are there any that are available for free?

Re: [ADMIN] Syntax question

2004-06-07 Thread Jim Seymour
Jeff Stout [EMAIL PROTECTED] wrote: I am fairly new to postgres, I need to know how to switch databases once I'm in a psql session. I can't seem to find the command for \h , maybe I just blind |-; \? is your friend... $ psql Password: Welcome to psql 7.4.2, the PostgreSQL interactive

Re: [ADMIN] E-R Tool

2004-06-07 Thread Ray Ontko
Renney, We've recently begun using Mogwai: http://mogwai.sourceforge.net/erdesigner/erdesigner.html It's a lot like ERwin, but is open source and written in Java, so it runs almost anywhere. We run it under Windows and Linux. I assume that it will reverse engineer any foreign key

Re: [ADMIN] E-R Tool

2004-06-07 Thread Andrew Biagioni
http://www.fabforce.net/downloads.php Jaime Casanova wrote: Hello, Db-designer is a nice tool, can work with importing Oracle databases, and use it with PG and MySQL. Hope this helps BR, Miguel Can someone suggest an E-R tool that will read a _PG_ database and create an E-R diagram - crows feet

Re: [ADMIN] Syntax question

2004-06-07 Thread Andrew Biagioni
Jeff, you need to look under \? (psql commands), not \h (SQL commands). Anyway, what you need is: \c[onnect] [DBNAME|- [USER]] connect to new database (currently [...]) Jeff Stout wrote: I am fairly new to postgres, I need to know how to switch databases once I'm in a psql

Re: [ADMIN] Tsearch1 problem

2004-06-07 Thread Oleg Bartunov
On Tue, 24 Feb 2004, Rajesh Kumar Mallah wrote: Greetings, The function txt2txtidx of tsearch1 crashes the backend in my installation when it is called with a text where '-' is immediately followed by a number. example, please. Cut'n paste from psql console would be fine. Also, what's

[ADMIN] out of memory error

2004-06-07 Thread Adi Alurkar
Greetings, During testing of our application we ran into a very odd error: very randomly during the test the postgresql log file showed a ERROR: 53200: out of memory we changed the logging configuration to log statements causing errors and found the error to be caused by a SELECT, here is

Re: [ADMIN] out of memory error

2004-06-07 Thread Jie Liang
I had a similar problem after upgrade to 7.4.2, Try: SET enable_hashagg = false; Before you execute that SELECT stmt If you don't want disable it in postgresql.conf Jie Liang -Original Message- From: Adi Alurkar [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 5:01 PM To: [EMAIL

[ADMIN] Linux (Debian Woody), psql: Can't delete or create databases

2004-06-07 Thread Phillip R. aka Qbert
Hi. I'm having some serious trouble with Postgres on Debian Linux (3.0 aka Woody), and hope somebody can help. The PostgreSQL DB Server I'm running is the default that comes with Debian Linux 3.0. From the Information the APT packaging tool can provide the version number is something between