RE: pg_dump problem

From: "C(dot) R(dot) Oldham" <cro(at)ncacasi(dot)org>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org>
Subject: RE: pg_dump problem
Date: 2001-06-13 15:52:56
Message-ID: F540EC7334CFED478994B370191C960915BC@exchange01.ncacasi.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


cro(at)nca(dot)asu(dot)edu wrote:
> > 'ERROR: user_id_sequence: Permission denied.

tgl(at)sss(dot)pgh(dot)pa(dot)us wrote:
> Hmm. Which user is pg_dump connecting as?

Ahh! I understand. Exporting a sane value for PG_USER fixed it.

This (and -u) are the only ways to change the user that pg_dump connects
as?

--
/ C. R. (Charles) Oldham | NCA-CASI \
/ Director of Technology | Arizona State University \
/ cro(at)nca(dot)asu(dot)edu | V:480-965-8703 F:480-965-9423 \

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-06-13 15:53:35 Re: Re: Does PostgreSQL support EXISTS?
Previous Message Tom Lane 2001-06-13 15:50:26 Re: Re: Does PostgreSQL support EXISTS?