Re: [GENERAL] error on pg_restore

2015-12-08 Thread Adrian Klaver
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

[GENERAL] error on pg_restore

2015-12-08 Thread anj patnaik
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