[ADMIN] su: /bin/bsh Permission denied

2005-07-24 Thread 梁炳場
The error message is "su: /bin/bash Permission denied". The following is my startup script. It is okay when it is run on command line. It fails when it is called in /etc/init.d as Linux boots. What do I need to do? Thanks #! /bin/sh # PostgreSQL startup/shutdown script # # case "$1" in start)

[ADMIN]

2005-07-24 Thread Mark P Anderson
approve vYyvLS unsubscribe pgsql-admin [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] caching table/query

2005-07-24 Thread Chris Travers
Tsirkin Evgeny wrote: Well i guess that there are cases where that is not so.However i understand that postgres does not have any way accept the automatic. Largely true. There may be ways of forcing a from-memory query once the system is in place, but I am not sure that this is always wha

Re: [ADMIN] pg_restore hangs on 'some' HP-UX machines

2005-07-24 Thread Gopal Srinivasa
Hi Chris, > So basically it is hanging when writing to the socket. Does > this change if you use TCP/IP (say adding a -h localhost to > your commandline)? This seems to work on one of my test machines where pg_restore was failing before...still need to make sure that this will work always, b

Re: [ADMIN] functions vs stored procedures

2005-07-24 Thread Ezequiel Tolnay
Alvaro Herrera wrote: Wow, incredible. You misread the whole documentation. I certainly did, I read it with more care this time. It is a great solution when we're required to return a single record with a custom type, which are few but there certainly are. I wonder if you know any tricks t

[ADMIN] help! I can not start postgreSQL service!

2005-07-24 Thread Jiang Ma
Hi everyone, I got a problem. When I try to start postgreSQl service in Windows, I can not start it. The error message is "Could not start the postgreSQL service on Local Computer. The service did not return an error. This could be an interal Windows error or an internal service error". I apprecia

[ADMIN] Corrupt table, is zero_damaged_pages available in v7.2?

2005-07-24 Thread Eric Comeau
We have "one" corrupted table in a v7.2.4 database. The others are good. We have identified the table should have 25 rows in it, and using pg_dump we can get the first 10. I was wondering if we could use the zero_damaged_pages under v7.2 to hopefully skip over the corrupted data and read the re