Delicious      Technorati      Blinklist      Furl      Reddit

TimeTrex Time and Attendance

TimeTrex Time and Attendance


* FAQ    * Search
* Login   * Register

All times are UTC - 8 hours [ DST ]




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
PostPosted: Tue Sep 12, 2006 10:24 am 
Offline

Joined: Thu Jul 27, 2006 11:58 am
Posts: 254
Locate your pg_hba.conf file, usually it is located at: /var/lib/pgsql/data/pg_hba.conf

Once located, edit it and confirm that the "local" line at the bottom has method "password".

# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all password
# IPv4 local connections:
host all all 127.0.0.1/32 password
# IPv6 local connections:
host all all ::1/128 password

Restart PostgreSQL to make sure the changes take effect, then
confirm that you are logged in as root and follow the below commands:

[root@timetrex ~]# su postgres
[postgres@timetrex root]$ createuser --interactive -P timetrex
Enter password for new role: <password>
Enter it again: <password>
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
CREATE ROLE

[postgres@timetrex root]$ psql template1 timetrex
Welcome to psql 8.1.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

template1=> create database timetrex;
CREATE DATABASE
template1=>\q
[postgres@timetrex root]$

You should now be ready to install TimeTrex with the "timetrex" user.

If you made a mistake, the easiest thing to do is drop the user and database and start over again. You can do that with these commands at the shell:

dropuser timetrex
dropdb timetrex

_________________
Mike Benoit


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: Bing [Bot] and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  


Time and Attendance




Powered by phpBB® Forum Software © phpBB Group