Re: [Bacula-users] Postgres information

2005-09-12 Thread Martin Simmons
 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

2005-09-12 Thread Aleksandar Milivojevic

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