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 cre

[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: WA

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] 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 subs

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 p

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 search