Search Postgresql Archives

Re: Installing PostgreSQL under Cpanel

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Erick Papadakis wrote:
> Thanks Thomas.

Please don't top-post, it disturbes the flow of the communication.

> But:
> 
> - "psql" at the command says
>  > psql: FATAL:  database "root" does not exist
> 
> - "psql -d postgres" at the command says
>  > psql: FATAL:  role "root" does not exist
> 
> How should I create the first database, or the first user etc? The
> links you suggested are all *after* I login to the interface?

There's documentation about that too, at the end of the installation
instructions IIRC.

> How should I start the postgresql service? How should I check it is on?

This suggests you're using PostgreSQL on Windows. I don't know anything
about Windows (except that it's suitable for games :P), so can't help
you with that. However, I can solve one of your other problems:

Windows doesn't really have a native "interactive shell"; I suppose
cmd.exe is the closest thing. I suppose that's what you were looking for
when you were told to use psql - which wasn't the correct answer in that
case.

> Thanks
> 
> 
> On 1/23/07, Thomas Kellerer <spam_eater@xxxxxxx> wrote:
>> On 23.01.2007 15:10 erick.papa@xxxxxxxxx wrote:
>> > Now what?
>> >
>> >
>> > 1. Where's the interactive shell?
>> http://www.postgresql.org/docs/8.2/static/app-psql.html

I think this has caused some confusion. Although psql is an interactive
shell, it is a shell to the database - not to the OS. I think the OP's
question refered to interactive shells to the OS.

This isn't the first time for this question to rise. Apparently some
documentation refers to the term without explaining what it is (which
would indeed be quite unnecessary for UNIX users). Maybe a documentation
patch is in order?

>>  > How can I start creating a database,
>> http://www.postgresql.org/docs/8.2/static/app-createdb.html

createdb is a command line utility, that you can start from your
"interactive shell". Using cmd.exe, you probably need to set your PATH
to where createdb.exe(?) and createuser.exe(?) were installed.

>> > creating users, testing things out?
>> http://www.postgresql.org/docs/8.2/static/app-createuser.html

See above.

-- 
Alban Hertroys
alban@xxxxxxxxxxxxxxxxx

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux