Discussing the news of the BeOS Community.
|
FAQ Search Statistics Memberlist Usergroups Register
|
Profile Login to check your private messages Login |
|
Bone, PostgreSQL - Little help?
|
|
The BeOSJournal. Forum Index -> BeBits |
Printable version |
Summary Rating For >> Bone, PostgreSQL - Little help? |
Average Rating: 0.00 :: Min Rating: 0 :: Max Rating: 0 :: Number of Ratings: 0
|
You are not authorized to rate this topic |
|
|
:: |
Porting UNIX/POSIX stuff |
Author |
Message |
Wombat
Pencil Pusher
Gender:
Joined: 15 Jun 2002
Posts: 21
Location: United Kingdom
|
Posted: Wed Aug 14, 2002 5:55 pm Post subject: Bone, PostgreSQL - Little help?
|
|
|
|
Ok, I've just installed Bone and directly after the install (after a reboot) I've installed PostgreSQL. However I cant seem to get PostgreSQL to work.
I have initialised that database to /boot/home/database
I run "postmaster -D /boot/home/database -h 127.0.0.1 -p 5432" and postmaster starts running and spawns 3 versions of itself (is this normal?)
Then I open a new terminal window and run "createdb -D /boot/home/database -h 127.0.0.1 -p 5432 mydb" but it tells me the connection was refused and to check I have postmaster running where it should be.
I haven't configured Bone at all, I just ran the install - anything else I should have done here?
Can anyone offer me any suggestions?
|
|
Back to top |
|
|
moooooooo
Pencil Pusher
Joined: 12 Jun 2002
Posts: 27
Location: Melbourne, Australia
|
Posted: Thu Aug 15, 2002 7:01 am Post subject:
|
|
|
|
Wombat, you want to start up postmaster with a -i (internet sockets)
this is because we dont have sockets == file descriptors.
you dont need to specify the port unless you have used anything other that 5432.
there's also a config file pg_hba.conf which you might want to look at.
at the very end of it you will see this:
Code: |
# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT
local all trust
host all 127.0.0.1 5 trust
|
if you are accessing this database server from another PC you would add in :
host all xxx.xxx.xxx.xxx 255.255.xxx.xxx trust
where the first xxx. is your tcp/ip address and the 255. is the netmask for the pc.
"all" is all databases. You can lock this down by specifying individual databases.
you can also add in the whole network by doing something similar
cheers
peter
ps have a read:
http://beos.loved.com/projects/postgresql/
i think its that. if not, http://beos.loved.com/postgresql/
[/code]
Last edited by moooooooo on Fri Aug 16, 2002 8:59 am, edited 1 time in total
|
|
Back to top |
|
|
Wombat
Pencil Pusher
Gender:
Joined: 15 Jun 2002
Posts: 21
Location: United Kingdom
|
Posted: Thu Aug 15, 2002 3:28 pm Post subject:
|
|
|
|
Thanks moooooooo!
It worked perfectly!
|
|
Back to top |
|
|
|
|
The BeOSJournal. Forum Index -> BeBits |
All times are GMT + 1 Hour
Email to a Friend.
|
Page 1 of 1 |
|
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 vote in polls in this forum
|
Powered by phpBB 2.0.1 © 2001 phpBB Group
|