[ADMIN] 8.1.0 - PITR - cp: cannot stat

2005-12-06 Thread Dan The Man
Hi, I found this old post - see the bottom of the message. I'm having a similiar issue. After a PITR everything looks good. I do see the following in the logs: Can that be safely ignored? cp cannot stat `/sprj/sqldumps_Linux.pgsql_carp5442/0002.history': No such file or directory

[ADMIN] --with-perl

2005-12-01 Thread Dan The Man
Hi, I didn't build (./configure --with-perl) the makefile with perl and a developer wants it now. Is there a way to add perl with out a complete re-instsall like with the create lang command? Has anyone read anything about about the perl PL ? Someone in our group said he read its really

[ADMIN] command line options to pass to the postmaster - controlling UNIX socket permiss

2005-11-29 Thread Dan The Man
Hi, I'm running postgres on a Linux server SuSE SLES. When I run postgresql 8.0.3, I get /tmp/.s.PGSQLl.5432 socket open with group and owner permissions. The group permissions are the default group of the postgres account and the owner is postgres. If I want to start postgres with a

[ADMIN] invalid length of startup packet

2005-11-29 Thread Dan The Man
Hi, I've been using postgresql v810 for a couple of weeks. I notice when I start it up I get 'invalid lenth of startup packet' On a database that I just initialized I get ' incomplete startup packet' after I first started it. This never happened that I can see in 8.0.3. Does any one

[ADMIN] upgrade from 8.0.3 to 8.1.0

2005-11-08 Thread Dan The Man
Hi, I have enough resources on my 3 postgresql servers to run more than one instance of postgres. Is there a way to keep my production db up and running in 8.0.3 while I also run 8.1.0 on the same server? Then, I could copy the data and support two databases until things looked good. Then,