From: | anj patnaik <patna73(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | error on pg_restore |
Date: | 2015-12-08 17:00:31 |
Message-ID: | CAEQKwSnBhhozenNvxU+fudjiDz=Zz8NTh6XB61jtWz75Tdd7YA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I created a user pguser and gave it all the privileges on database RIC.
CREATE USER pguser WITH PASSWORD 'xyz123!';
GRANT ALL PRIVILEGES ON DATABASE "RIC" to pguser;
The database RIC was created by user postgres earlier.
Now, when I run the pg_restore I get an error:
xzcat "postgres-071215200001-database" | PGPASSWORD=xyz123!
/opt/PostgreSQL/9.4/bin/pg_restore -h onxv0097 -U pguser -d RIC -c -p 5432
-v
pg_restore: connecting to database for restore
pg_restore: dropping CONSTRAINT recorder_pkey
pg_restore: dropping TABLE DATA recorder
pg_restore: dropping TABLE recorder
pg_restore: creating TABLE recorder
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 173; 1259 58915 TABLE
recorder postgres
pg_restore: [archiver (db)] could not execute query: ERROR: must be member
of role "postgres"
Command was: ALTER TABLE recorder OWNER TO postgres;
From | Date | Subject | |
---|---|---|---|
Next Message | Selim Tuvi | 2015-12-08 17:36:37 | Re: bdr manual cleanup required |
Previous Message | Selim Tuvi | 2015-12-08 16:50:20 | Re: BDR: ALTER statement hanging |