Re: [Bacula-users] Postgres information
On Sun, 11 Sep 2005 01:11:08 -0500, Tom Bishop [EMAIL PROTECTED] said: Tom I'm having a time getting my postgres tables to drop, I had this working Tom and now I can't seem to remember which user was allowed to drop the Tom tables. I think I used the postgres user, but when I su to that user, Tom I get an error saying there is no postgres database. When I try it from Tom a user it connects to the bacula database but doesn't have the privilige Tom to delete the tables. Can anyone point me too some more detailed Tom reading on how to set up/delete the postgres tables? Thanks. The postgres superuser is called pgsql for me. e.g. try something like drop_postgresql_tables -U pgsql __Martin --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Postgres information
Tom Bishop wrote: I'm having a time getting my postgres tables to drop, I had this working and now I can't seem to remember which user was allowed to drop the tables. I think I used the postgres user, but when I su to that user, I get an error saying there is no postgres database. When I try it from a user it connects to the bacula database but doesn't have the privilige to delete the tables. Can anyone point me too some more detailed reading on how to set up/delete the postgres tables? Thanks. Use -d option to specify database (for example psql -d bacula). --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Postgres information
I'm having a time getting my postgres tables to drop, I had this working and now I can't seem to remember which user was allowed to drop the tables. I think I used the postgres user, but when I su to that user, I get an error saying there is no postgres database. When I try it from a user it connects to the bacula database but doesn't have the privilige to delete the tables. Can anyone point me too some more detailed reading on how to set up/delete the postgres tables? Thanks. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.21/96 - Release Date: 9/10/2005 --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users