Navigation Menu.
The BeOSJournal. Reporting the news of the BeOS Community.
  Discussing the news of the BeOS Community.
FAQFAQ    SearchSearch    Site Statistics.Statistics    MemberlistMemberlist    UsergroupsUsergroups    RegisterRegister
   ProfileProfile   Login to check your private messagesLogin to check your private messages   LoginLogin

Bone, PostgreSQL - Little help?

 
Post new topic   Reply to topic    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
:: View detailed info
    :: Post Porting UNIX/POSIX stuff  View next topic  
Author Message
Wombat
Pencil Pusher
Pencil Pusher


Gender:Gender:Male
Joined: 15 Jun 2002
Posts: 21
Location: United Kingdom

PostPosted: Wed Aug 14, 2002 5:55 pm    Post subject: Bone, PostgreSQL - Little help? Reply to topic Reply with quote

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. icon_sad.gif

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
View users profile Send private message Send email
moooooooo
Pencil Pusher
Pencil Pusher



Joined: 12 Jun 2002
Posts: 27
Location: Melbourne, Australia

PostPosted: Thu Aug 15, 2002 7:01 am    Post subject: Reply to topic Reply with quote

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
View users profile Send private message Send email Visit posters website
Wombat
Pencil Pusher
Pencil Pusher


Gender:Gender:Male
Joined: 15 Jun 2002
Posts: 21
Location: United Kingdom

PostPosted: Thu Aug 15, 2002 3:28 pm    Post subject: Reply to topic Reply with quote

Thanks moooooooo! icon_biggrin.gif

It worked perfectly!
Back to top
View users profile Send private message Send email
Post new topic   Reply to topic    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