Fwd: Restore problem from 8.4 backup to 9.0

Поиск
Список
Период
Сортировка
От Adam Wizon
Тема Fwd: Restore problem from 8.4 backup to 9.0
Дата
Msg-id 19DC5A2C-BA59-4A0C-BC67-ACAE51E83E5A@mac.com
обсуждение исходный текст
Ответ на Re: Fwd: Restore problem from 8.4 backup to 9.0  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
If I run the admin tool from my postgres account, that works fine since postgres is the owner.  

Subject: Re: Fwd: [GENERAL] Restore problem from 8.4 backup to 9.0

Thanks for the fast reply.  I must have still been connected to the older database somehow.  I cleaned up my installation and restored the database.  No error messages this time.  I need to change the pg_hba.conf file.  I read the documentation and its supposed to be in the data directory (which is locked), but it doesn't seem to be there.  Is there an easy way to create the file in the data directory (without overriding access privileges) at this point?

That's where it would normally be, but try "show hba_file;" if you think
the packager of your distribution put it somewhere else.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: disable trigger all
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: disable trigger all