DB on Linux server?

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

DB on Linux server?

Postby fyl2u » Mon Jun 09, 2008 3:46 pm

Hi all..

Would it be possible to have my database on my Debian Linux gateway server, so that I can access it from PT3 running on either my XP PC or my laptop?

(So that I don't have to mess around copying files from computer to computer every time I play on one or the other computer)

Thanks in advance.

Phil.
fyl2u
 
Posts: 187
Joined: Tue Mar 11, 2008 5:15 pm

Re: DB on Linux server?

Postby WhiteRider » Mon Jun 09, 2008 4:04 pm

Yes, it's possible.

Have a look at this post in the FAQs: How To: Network PostgreSQL Database.

I'm not going to be able to help much beyond that myself, but if that doesn't get you sorted, then ask again and I'm sure some of the postgres experts will help.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: DB on Linux server?

Postby hammerHead » Tue Jun 10, 2008 2:14 am

Yes, it is possible!, I have already done it!

I have PostgreSQL running on my Linux server machine. I have set up both PT2 and PT3 to connect to my Linux PostgreSQL db server, which both, my laptop and tower case can connect to without problems, but the databases are separate due the the database schema.



fyl2u wrote:Hi all..

Would it be possible to have my database on my Debian Linux gateway server, so that I can access it from PT3 running on either my XP PC or my laptop?

(So that I don't have to mess around copying files from computer to computer every time I play on one or the other computer)

Thanks in advance.

Phil.
hammerHead
 
Posts: 51
Joined: Sun May 25, 2008 3:47 am

Re: DB on Linux server?

Postby MrFlibble » Tue Jun 10, 2008 4:11 pm

Do you find importing hands over the network to the database is much slower than running in on a local machine?
MrFlibble
 
Posts: 58
Joined: Sat Mar 08, 2008 7:30 pm
Location: handhq.com for datamined hands

Re: DB on Linux server?

Postby hammerHead » Wed Jun 11, 2008 6:29 pm

MrFlibble wrote:Do you find importing hands over the network to the database is much slower than running in on a local machine?


Not at all, but then again, I have gigabit private network at home and a very fast HD in my Linux server.
hammerHead
 
Posts: 51
Joined: Sun May 25, 2008 3:47 am

Re: DB on Linux server?

Postby fyl2u » Wed Jun 11, 2008 8:43 pm

Cooool.

I'll give this a go tomorrow.

Thanks guys.

HammerHead, I might need to pick your brains later if that's ok? ;)
fyl2u
 
Posts: 187
Joined: Tue Mar 11, 2008 5:15 pm

Re: DB on Linux server?

Postby fyl2u » Tue Jun 17, 2008 12:06 pm

OK, I'm going to try this.

The trouble is, I'm pretty clueless when it comes to Linux - I only know a few basic commands... someone else set the server up, then moved out, so I inherited it as part of a deal that also bought me a nice leather sofa and a DVD player. :)

After reading that post in the FAQs, I'm little more the wiser :D

Anyone in the mood to drip-feed me the instructions to get this going? :D

It's a Debian server and I'll be connecting to it using Putty.
fyl2u
 
Posts: 187
Joined: Tue Mar 11, 2008 5:15 pm

Re: DB on Linux server?

Postby keggler » Tue Jun 17, 2008 12:10 pm

putty is only really useful for sealing your windows... ;) it makes a real mess if you put it in your computer.

better to use a network instead.

susan
keggler
 
Posts: 640
Joined: Sun Jun 01, 2008 4:53 am

Re: DB on Linux server?

Postby fyl2u » Tue Jun 17, 2008 12:12 pm

keggler wrote:putty is only really useful for sealing your windows... ;) it makes a real mess if you put it in your computer.

better to use a network instead.

susan


:lol: :lol: Thanks for that. :D
fyl2u
 
Posts: 187
Joined: Tue Mar 11, 2008 5:15 pm

Re: DB on Linux server?

Postby hammerHead » Wed Jun 18, 2008 2:46 am

To bad I couldn't ssh into the Debian box and do it myself, It would be a lot quicker and easier than "drip-feeding" you all the complicated stuff. I do run many Linux server machines in my home as well as an assortment of Window machines as well. I have also ssh into other peoples, as well as friend Linux boxes and have done Administrative duties for them.

I am certified in Linux as well as an MCSE (Microsoft Certified System Engineer).

It could be as easy opening a port through your firewall to the Debian box and getting me your IP address so I may ssh into your network, but this would involve a level of blind trust on your part. Just an idea...

Jeff


fyl2u wrote:OK, I'm going to try this.

The trouble is, I'm pretty clueless when it comes to Linux - I only know a few basic commands... someone else set the server up, then moved out, so I inherited it as part of a deal that also bought me a nice leather sofa and a DVD player. :)

After reading that post in the FAQs, I'm little more the wiser :D

Anyone in the mood to drip-feed me the instructions to get this going? :D

It's a Debian server and I'll be connecting to it using Putty.
hammerHead
 
Posts: 51
Joined: Sun May 25, 2008 3:47 am

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests