| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | ElayaRaja S <elayaraja(dot)s(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Help |
| Date: | 2005-04-28 15:34:24 |
| Message-ID: | 1114702463.13303.1341.camel@state.g2switchworks.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2005-04-28 at 09:51, ElayaRaja S wrote:
> After login as su postgres
> I am unable to create the db;
>
>
> $ createdb -E utf8 -U system myDB;
> ERROR: permission denied to create database
> createdb: database creation failed: ERROR: permission denied to create database
What's with the -U system in there?
As the postgres user, (i.e. either leave out the -U system or make it -U
postgres) it should work fine. Oh, and you MAY want to just stick to
lower case names for databases, tables, fields etc... It's easier in the
long run.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Caduto | 2005-04-28 16:18:00 | Is there a bug in the win32 pg_restore (version 8.02) ? |
| Previous Message | Fritz Bayer | 2005-04-28 15:00:21 | ERROR: Could not convert UTF-8 to ISO8859-1 |