[ADMIN] two versions on same linux

Hi, I have redhat 7.3 and postgres 7.2 Is there a way to have 7.4 installed together with postgres 7.2 ? and both running at the same time, with of course different data directories. should i use the generic postgres or the rpm'd. The existing redhat has no passwords for postgres, and

[ADMIN] My connection only - Disable Trigger

My friends, I apologize if my english language is bad. I have question about trigger.. How to disable trigger, ONLY for my connection NOT others people connection (they will use the trigger) any solution ? Regards, Eko pranoto ---(end of

Re: [ADMIN] two versions on same linux

yup, just configure both on differnt ports - Original Message - From: Paul Gimpelj To: [EMAIL PROTECTED] Sent: Friday, May 21, 2004 12:14 PM Subject: [ADMIN] two versions on same linux Hi, I have redhat 7.3 and postgres 7.2 Is there a way to have

Re: [ADMIN] two versions on same linux

A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Paul Gimpelj) wrote: I have redhat 7.3 and postgres 7.2 Is there a way to have 7.4 installed together with postgres 7.2 ? and both running at the same time, with of course different data directories. should i use the generic

[ADMIN] Shared memory error using initdb on Solaris 8

Hello, I'm trying to install PostgreSQL 7.4.2 on a brand new SunFire 120 with 2GB of RAM but when I run initdb -D /usr/local/pgsql/data I get the following error: creating directory /usr/local/pgsql/data... ok creating directory /usr/local/pgsql/data/base... ok creating directory

Re: [ADMIN] Shared memory error using initdb on Solaris 8

Hello, I'm trying to install PostgreSQL 7.4.2 on a brand new SunFire 120 with 2GB of RAM but when I run initdb -D /usr/local/pgsql/data I get the following error: [snip] creating template1 database in /usr/local/pgsql/data/base/1... FATAL: could not create shared memory segment:

Re: [ADMIN] Shared memory error using initdb on Solaris 8

There we go. For reference, what page did you get that info and what did you search for to get it? Kevin - Original Message - From: Jim Seymour [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 21, 2004 10:57 AM Subject: Re: [ADMIN] Shared memory error using initdb on Solaris 8

Re: [ADMIN] Log query results?

Robert Creager [EMAIL PROTECTED] writes: I'm running 7.4.1 and am having problem when my app starts loading up on the database. I want to verify the data coming back from the queries is correct from the server side (not application side), as then I'll be sure my app is squirrelly (or the db

Re: [ADMIN] Shared memory error using initdb on Solaris 8

There we go. For reference, what page did you get that info and what did you search for to get it? Like I said: I derived it all from Google'ing on various search terms, IIRC. Probably things like postgresql+Solaris+shmmax and the like. I didn't save any URL references. Jim

Re: [ADMIN] Shared memory error using initdb on Solaris 8

Searching Google brought up this page. http://www.postgresql.org/docs/current/interactive/kernel-resources.html - Original Message - From: Jim Seymour [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 21, 2004 1:14 PM Subject: Re: [ADMIN] Shared memory error using initdb on

Re: [ADMIN] pg_hba.conf

On Thu, 2004-05-20 at 19:52, [EMAIL PROTECTED] wrote: I'm trying to access our test postgreSQL server via VPN and even though I already setup the host for the vpn's ip address, I'm still getting an error similar to host for vpn address does not exist What am I doing incorrectly? The

Re: [ADMIN] Clustering Postgres

On Thu, 2004-05-20 at 14:30, Kris Kiger wrote: Has anyone heard of clusgres or, better yet, had any experience with it? I came across it while searching for active clustering projects. http://www.linuxlabs.com/clusgres.html Thanks in advance for the info! I have heard of it but I've

Re: [ADMIN] My connection only - Disable Trigger

On Fri, 2004-05-21 at 04:49, Eko Pranoto wrote: My friends, I apologize if my english language is bad. I have question about trigger.. How to disable trigger, ONLY for my connection NOT others people connection (they will use the trigger) any solution ? One way would be to have the

Re: [ADMIN] pg_hba.conf

Thanks Robert! I did that as well and still didn't work. Any other ideas? -Original Message- From: Robert Treat [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 4:41 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] pg_hba.conf On Thu, 2004-05-20 at 19:52, [EMAIL

Re: [ADMIN] pg_hba.conf

can you ping the server that postgresql is living on? or maybe your misrepresenting the error message... what program are you using to try and connect? can you verify that tcpip_sockets is turned on the server? also, if it is a database problem there will be an exact error message being

[ADMIN] database design tools.

hi, I was wondering if someone can give me some advice. I presently use pgaccess tcl based. But I would prefer a c or c++ client server admin , somewhat like mssql server enterprise edition. I am new to linux. so can anyone direct me to details documentation on accessing postgresql from