[GENERAL] PostgreSQL (file based) database restore

2006-04-08 Thread Bit Byter
I just did a file based database backup (stopped postmaster and zipped/copied all files under /usr/local/pgsql/data/* to a differnt location) How can I 'restore' the database and start using it? ---(end of broadcast)--- TIP 3: Have you checked our

[GENERAL] help needed (which group do I post these questions to?)

2006-04-07 Thread Bit Byter
I am getting a little desperate as I have not got any replies yet. I am wondering if this is the correct group for my questions. If not, please point me to the appropriate group. My questions revolve around libpq. 1). Does anyone know how to execute a stored procedure (i.e. PL/PGSQL function), us