[GENERAL] pg_dump warings

2006-04-30 Thread Rick Ellis
I did something foolish and now I'm getting warnings every time pg_dump runs (hourly from cron). Anybody have a suggestion on how to fix this? pg_dump: WARNING: owner of data type accountuser appears to be invalid pg_dump: WARNING: owner of data type adminuser appears to be invalid pg_dump:

Re: [GENERAL] pg_dump warings

2006-04-30 Thread Rick Ellis
In article [EMAIL PROTECTED], Devrim GUNDUZ [EMAIL PROTECTED] wrote: Create the user again with the same userid (I mean revert what you did). You can get this info from pg_tables and pg_authid(or pg_shadow, depending on your PostgreSQL version). It turned out to be some tables had been created

Re: [GENERAL] majordomo unmaintained, postmaster emails ignored?

2006-03-09 Thread Rick Ellis
In article [EMAIL PROTECTED], Roman Neuhauser [EMAIL PROTECTED] wrote: I've been waiting five months for the majordomo moderators to approve my subscription requests to several @postgresql.org mailing lists. I stopped getting any mail from postgresql.org last fall. Repeated attempts to subscribe

Re: [GENERAL] majordomo unmaintained, postmaster emails ignored?

2006-03-09 Thread Rick Ellis
In article [EMAIL PROTECTED], Marc G. Fournier [EMAIL PROTECTED] wrote: So how did you get this message? :( Via Usenet. -- http://yosemitephotos.net/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Can't connect to postgresql using 'psql -d database -U user -W'

2006-01-05 Thread Rick Ellis
In article [EMAIL PROTECTED], ctobini [EMAIL PROTECTED] wrote: tobini% psql -d template1 -U postgres -W password: postgres psql: FATAL: IDENT authentication failed for user postgres Do you have an idea about this problem ? Use the su command to become user postgres and then run the psql

Re: [GENERAL] Why database is corrupted after re-booting

2005-10-27 Thread Rick Ellis
In article [EMAIL PROTECTED], Welty, Richard [EMAIL PROTECTED] wrote: crappy disk drives and bad windows file systems, nothing more. Could even be crappy memory. -- http://yosemitecampsites.com/ ---(end of broadcast)--- TIP 4: Have you searched