Re: pg_dump problem
От | Paul Thomas |
---|---|
Тема | Re: pg_dump problem |
Дата | |
Msg-id | 20030723095137.A12844@bacon обсуждение исходный текст |
Ответ на | pg_dump problem ("Bob Nix" <bnix@Intranexus.com>) |
Список | pgsql-general |
On 22/07/2003 16:30 Bob Nix wrote: > I am trying to get pg_dump to work. I suspect that I am doing something > wrong - Here's my command, and the resulting message. > > "postgres" owns the database and the tables; all tables were created > under "postgres". > "postgres" has no password. > > The database is named "demo". > > === my command ==== > $ pg_dump -U postgres demo > demo.dump > > === resulting message === > pg_dump: [archiver (db)] connection to database "demo" failed: FATAL: > IDENT authentication failed for user "postgres" su to postgres from root should work but can be a PITA. I always create a super user for a standard unix user (i.e. me on my development box) and use that to create/own the databases. So the only time I actually need to su postgres is during installation/setup. HTH -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
В списке pgsql-general по дате отправления: