[ADMIN] Is there anyway to...

Hello all, Is there an existing mechanism is postgresql that can automatically increment/decrement on a daily basis w/out user interaction? The use case I'm considering is where a student is in some type of contract with an instructor of some sort, and that contract puts a time limit on the s

Re: [ADMIN] database "postgres" does not exist

Richard, Are you sure that you weren't typing an additional argument, such as: sudo -u postgres psql db_name Reason I ask is because, by default running the command psql assumes some things if you don't call them out explicitly such as: psql assumes: -h 127.0.0.1 -p 5432 (or whichever w

Re: [ADMIN] Database port changing issue

I'm sorry but this is wrong, localhost IS 127.0.0.1 and IS a fundamental component of TCP/IP. UNIX Domain sockets - known to most as file descriptors - are entirely different! localhost != UNIX Domain sockets! I wish people would read up on this to stop perpetuating the misunderstanding of '

Re: [ADMIN] Database port changing issue

Hello Chris, While yes, IF one were in a relative 'external' position - such as the Internet - attempting to connect to this database that was internal - assuming there was a firewall separating the two systems, one could possibly assume there is a firewall filter, preventing this connectivity

Re: [ADMIN] install postgre on windows XP, service failed to start.

Jeff Zhong wrote: I installing postgre SQL on Windowx XP Product: PostgreSQL 8.1 -- Error 1920. Service 'PostgreSQL Database Server 8.1' (pgsql-8.1) failed to start. Verify that you have sufficient privileges to start system services. I got this error when I try to install postgresql on wi

[ADMIN] install_driver(Pg) failed: Can't load Pg.so

OS = Solaris 9 PERL v = 5.8.7 postgreSQL = 8.0.1 I'm getting the following error when attempting to interface through my web browser, immediately after supplying the login information. Software error: install_driver(Pg) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/

Re: [ADMIN] reg:conninfo

I'm sorry, please don't confuse a UNIX domain socket with "localhost" which are _not_ the same at all. A UNIX domain socket is nothing more than a file *usually* located in a temporary directory, used for inter-process communication. "localhost" - 127.0.0.1, also used on any TCP/IP configured

Re: [ADMIN] Solaris 10/postgreSQL-8.0.1/--enable-thread-safety

[EMAIL PROTECTED] wrote: Hello, I succesfully compiled PGSQL 8.0.4 on solaris 10 (sparc). I used gcc and used CFLAGS="-O3 -pthreads". My configure instructions are as such: configure --with-includes=/usr/local/include --with-openssl -with-includes=/usr/local/ssl /include/ -with-libs=/usr/lo

Re: [ADMIN] Solaris 10/postgreSQL-8.0.1/--enable-thread-safety

Bruce, thanks for the help. did you have any supplemental suggestions that would 'help?' Bruce Momjian wrote: Louis Gonzales wrote: Hello List, I've compiled successfully, postgreSQL-8.0.1 on Solaris 9 with --enable-thread-safety, for use with Slony-I. A 2nd server

[ADMIN] Solaris 10/postgreSQL-8.0.1/--enable-thread-safety

Hello List, I've compiled successfully, postgreSQL-8.0.1 on Solaris 9 with --enable-thread-safety, for use with Slony-I. A 2nd server has Solaris 10 - when I attempt the same ./configure WITH --enable-thread-safety, I get an error about *** Thread-safety requires POSIX signals, which are not

Re: [ADMIN] postgresql-R

Jim Nasby wrote: On Mar 7, 2006, at 2:58 PM, Louis Gonzales wrote: Based on: Postgres based Replication Projects PG Replication Postgres-R: Dr. Kemme's Site, Paper, Publications, Replication Work, The Horus Project and Emsemble DRAGON: Database Replication based on Group Communicatio

Re: [ADMIN] postgresql-R

ter participant, for performance reasons. I will also join the Slony mailing list, very cool stuff. Kind Regards, Jim Nasby wrote: On Mar 7, 2006, at 2:58 PM, Louis Gonzales wrote: Based on: Postgres based Replication Projects PG Replication Postgres-R: Dr. Kemme's Site, Paper,

[ADMIN] postgresql-8.0.1/Solaris 9/Readline-5.1

Hello List, I currently recompiled postgresql-8.0.1 for Solaris 9, with the --enable-thread-safety, to appease the install of Slony-I which worked wonderfully I used the following configure line: ./configure --enable-thread-safety --without-readline and the remainder of the defaults were fine

Re: [ADMIN] postgresql-R

Tom Lane wrote: Louis Gonzales <[EMAIL PROTECTED]> writes: I was wondering if anybody has had much experience with postgresql-R, Postgres-R doesn't exist in any production-ready form. That software is an academic project that's based on a very old,

Re: [ADMIN] postgresql-R

: On Tue, Mar 07, 2006 at 03:29:37PM -0500, Louis Gonzales wrote: Hello, I was wondering if anybody has had much experience with postgresql-R, or being able to do database replication in a WAN environment. Basically, does anybody have any good links/docs on doing this with Solaris 9, po

[ADMIN] postgresql-R

Hello, I was wondering if anybody has had much experience with postgresql-R, or being able to do database replication in a WAN environment. Basically, does anybody have any good links/docs on doing this with Solaris 9, postgresql v8.0? Thanks in advance. begin:vcard fn:louis n:gonzales;louis e