On 12/08/2015 09:00 AM, anj patnaik wrote:
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 above does not mean what you think it does:
http://www.postgresql.or
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-0712152