LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-20-2003, 12:43 AM   #1
dsgdevil
Member
 
Registered: Jan 2003
Distribution: RedHat Linux 9
Posts: 126

Rep: Reputation: 15
postgreSQL


Is there any way to set a password for a pgsql user?
 
Old 02-20-2003, 05:22 PM   #2
rnturn
Senior Member
 
Registered: Jan 2003
Location: Illinois (Chicago area)
Distribution: Red Hat (8.0, RHEL5,6), CentOS, SuSE (10.x, 11.x, 12.2, 13.2), Solaris (8-10), Tru64, MacOS, Raspian
Posts: 1,113

Rep: Reputation: 65
Re: postgreSQL

Quote:
Originally posted by dsgdevil
Is there any way to set a password for a pgsql user?
ALTER USER username WITH PASSWORD 'password';

There are other parameters you can set/unset as well. Go into psql and issue ``\h alter user'' to see all the options.

Cheers...
Rick
 
Old 02-20-2003, 09:36 PM   #3
dsgdevil
Member
 
Registered: Jan 2003
Distribution: RedHat Linux 9
Posts: 126

Original Poster
Rep: Reputation: 15
command not found?
 
Old 02-20-2003, 11:30 PM   #4
rnturn
Senior Member
 
Registered: Jan 2003
Location: Illinois (Chicago area)
Distribution: Red Hat (8.0, RHEL5,6), CentOS, SuSE (10.x, 11.x, 12.2, 13.2), Solaris (8-10), Tru64, MacOS, Raspian
Posts: 1,113

Rep: Reputation: 65
Quote:
Originally posted by dsgdevil
command not found?
What part of the following os generating that error message?


$ psql
Welcome to psql ...

postgres=# alter user smithj with password 'jabberwocky';
ALTER USER
postgres=# \q
$


If psql cannot be found then it sounds like the PostgreSQL binaries are not in your PATH. And possibly the LD_LIBRARY_PATH environment variable is missing the location of the PG libraries.

I have everything installed under /opt/postgresql so users that need to use psql need to have


export PATH=${PATH}:/opt/postgresql/bin
export LD_LIBRARY_PATH=/opt/postgresql/lib


defined in their environment. Check that and let me know what happens then.

Cheers...
Rick
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
PostgreSql sijomon_nd Fedora 1 09-27-2005 10:27 PM
PostgreSQL 7.3.2 redhatrosh Programming 6 06-01-2005 09:15 PM
need help in postgresql yawhum80 Linux - Newbie 0 10-28-2003 11:03 AM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 03:50 AM
PostgreSQL dorian33 Linux - Software 3 01-15-2003 05:01 PM


All times are GMT -5. The time now is 06:08 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration