Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / General DB Topics / General DB Topics / June 2003

Tip: Looking for answers? Try searching our database.

PostgreSQL: user-id

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Habib Seifzadeh - 26 Jun 2003 07:02 GMT
hi all!
i installed psql in linux installation time and it's started in boot time
properly but it hasn't any user-id; i tried psql -U root, psql -U su and
much more, but none of them worked.
Is there any built-in user-id in postgresql or haw can i add user-id?
of course, i worked with MS SQL but don't have any info about postgresql at
all. thank you in anticipation if you inform me about some basic commands of
postgresql and some GUI interactive tool for dealing with databases in
linux.
bye,
habib
Christopher Browne - 26 Jun 2003 13:35 GMT
Centuries ago, Nostradamus foresaw when "Habib Seifzadeh" <habib@sabaa.com> would write:
> i installed psql in linux installation time and it's started in boot time
> properly but it hasn't any user-id; i tried psql -U root, psql -U su and
[quoted text clipped - 4 lines]
> postgresql and some GUI interactive tool for dealing with databases in
> linux.

Try "psql -U postgres"; that should work better, although possibly
only a bit; it'll then complain that there is no database called
"postgres."

Try, instead, "psql -U postgres -l", which will list the databases
that exist.  (Probably just the "template" ones, template0 and
template1.)

One of the first things you should do is to create a user for your
_own_ id; there's a script called "createuser" that does that.  Once
you do that, you won't forcibly need to specify "-U".

The second thing to do is to, as that user, create a database that
you'll use to actually put data in.  "createdb" is, not surprisingly,
the appropriate command for that.

See the documentation at http://www.postgresql.org/docs/ for more
information...
Signature

select 'cbbrowne' || '@' || 'ntlug.org';
http://www3.sympatico.ca/cbbrowne/rdbms.html
"If you  pick up a starving dog  and make him prosperous,  he will not
bite you; that  is the principal difference between a  dog and a man."
-- Mark Twain

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.