install with postgresql network settings

[zedjr]

Can i install postgresql 8.37 and set the network settigsn there so i can access postgresql from another computer and not go thru the manual steps.thanks

[kraada]

Yes you can.

The How To: Network PostgreSQL Databases may help you with the settings.

[zedjr]

i mean is ther a way when u do the install of postgresql to set the settings thru the automated install.

[zedjr]

At bottom of tutorial ti sais this below. I am confused. Where do i make these cfhanges and how. it sounds liek it is asking me to make changes in some file but am lsot to which as ipconfig brings me up a visual screen in dos i can not change. please explain. also in this part "listen_addresses = '*'" what is "'*'"" this. I am not familar with this keystroke.


"My IP address here is 192.168.1.16, so my server's ip address is the same. Therefore, to log into this database from my other computers in the house the server:port:pass is - 192.168.1.16:5432:dbpass. Substitute your information to access your database from another computer in your local network. Also, if you have removed password authentication from your server, please substitute "trust" for "md5" in the line you are adding to your pg_hba.conf file."

Good luck!

[kraada]

You make the changes in the postgresql.conf file. Click Start --> Programs --> PostgreSQL --> Configuration Files -> Edit postgresql.conf to find the file.

[zedjr]

i think it is the pg.hba file adn not postgres.conf but am nto sure and how exactly do i change it. i am so lost to do this and made first couple changes as they u can follow but i cant seem to follow this. please explain this.server port pass. where do i put this adn what do i put. i am a noob at thsi and am so lost on this part of tutorial.

[kraada]

There's a change to pg_hba.conf as well, but that wasn't the change to listen_addresses.

So there's two steps:
(1) Update pg_hba.conf on the server
(2) Update postgres.conf on the server

In (1) you want to click Start --> Programs --> PostgreSQL --> Edit pg_hba.conf.

Add a line at the bottom which is the IP address of the Client (that is the computer that will be connecting). If you're on a local subnet you can add the entire local subnet using CIDR notation: 192.168.1.0/24 will add ALL addresses on the 192.168.1.x subnet. If you want just a specific computer, you would add a.b.c.d/32.

You get this IP address of the client by running ipconfig /all at the command prompt.

Then on the server you edit the postgres.conf and set listen_addresses = '*' meaning "accept incoming connections from all addresses". If you don't do this, PostgreSQL won't accept connections from other than the local machine.

Once both changes are made, save the files and restart the PostgreSQL server and you will be able to connect from your client machine.

[zedjr]

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all 192.168.1.0/24 trust

this is how i have it. DO i need to change anything. PT3 wont run on client unless postgresql is installed. What do i need to do on client end to make db connection to server end.

[kraada]

Edit the C:\Program Files\PokerTracker 3\Data\Config\PokerTracker.cfg file and remove everything in the [Databases] section.

Restart PT3. It will ask you for the details on your postgres server, put in the IP address of your server, the port should stay the same (5432) and user postgres and password doesn't matter since you're using 'trust'. Once you do that, it should connect. You don't need postgres installed on the same computer as the PT3 client.

[zedjr]

a question about not installing postgres on client computer. WOuld it be better if client computer is much faster to install postgresql on client computer. I mean i am using ram i guess under postgres processes to do queries and such. can i do those form client computer's ram somehow,, like if postgresql was installed on client computer. my real question is how can i put the speed of client computer to good use.