Обсуждение: 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