Re: pg_restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: s(dot)chava(at)wcom(dot)com (Srinivasa Rao Chava)
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore
Date: 2002-02-06 16:33:30
Message-ID: 6699.1013013210@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

s(dot)chava(at)wcom(dot)com (Srinivasa Rao Chava) writes:
> Archiver(db): Could not execute query. Code = 7. Explanation from
> backend: 'ERROR: mysequence.setval: you don't have permissions to set
> sequence mysequence

Hmm, I think I see an oversight in pg_dump. Exactly what options did
you give to pg_dump and pg_restore?

regards, tom lane

In response to

  • pg_restore at 2002-02-06 15:47:38 from Srinivasa Rao Chava

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Felipe Nascimento 2002-02-06 16:34:58 Persistent Connections with PHP and PostgreSQL
Previous Message Manuel Trujillo 2002-02-06 16:23:44 Re: pg_restore