Обсуждение: Help

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


--
Warm Regards,

S.ElayaRaja
Mobile:  (+91) 98450 59540
E-Mail:  elayaraja.s@gmail.com
            raja_nk@hotmail.com

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.

Hi,
I just tried to restore a db with the win32 pg_restore that shipped with 8.02 and I get to the part where
it prompts me for the password, and I enter it, then I get the following error:

C:\>pg_restore.exe --ignore-version --verbose --dbname=mandi_test -W -U postgres
  --port=5432 --host=192.168.1.23 "C:\Documents and Settings\Administrator\Desktop
\mandi.bak"
pg_restore: connecting to database for restore
Password:
pg_restore: [archiver (db)] connection to database "mandi_test" failed: FATAL:
password authentication failed for user "postgres"
pg_restore: *** aborted because of error


I have the pg_hba.conf for my host set to md5, and if I change it to trust then I can do the restore.

update:  I just tried the pg_restore that has a version number of 8.0 and it works, definately seems to be
a bug in the 8.02 version (win32)

--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql 8.x
http://www.amsoftwaredesign.com