R: [ADMIN] VACUUM FULL ANALYSE hanging

2007-05-04 Thread Gabriele Bartolini
Hi guys, thanks for your answer. Unfortunately I have no superuser privileges on that server, but I have tried to look it up closely with our administrator today. I launched the VACUUM FULL ANALYSE command last night on a table, and it is still running. Now, I want to finish it and see h

[ADMIN] Adding a port to postgresql.conf

2007-05-04 Thread Carol Walter
Greetings, Can I add a port in postgresql.conf and still maintain 5432? If so, what is the correct syntax? Carol Walter ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if

Re: [ADMIN] Adding a port to postgresql.conf

2007-05-04 Thread Peter Eisentraut
Am Freitag, 4. Mai 2007 15:11 schrieb Carol Walter: > Can I add a port in postgresql.conf and still maintain 5432? No. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL

[ADMIN] Error when trying ssl

2007-05-04 Thread Carol Walter
Hello, We are doing some major system maintenance tonight. One of the things we wanted to do was to start using ssl for connections to Postgres. After we made what the documentation says are the necessary changes to postgresql.conf, pg_hba.conf and created the .key and .crt file, I tri