Putting the DB in postgreSQL on a Web 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

Putting the DB in postgreSQL on a Web Server

Postby VincenzoMancini » Fri Aug 22, 2008 9:40 am

Hey all,

I have a Web Host who can provide postgreSQL DB hosting.

I have the host address, port etc. And PT3 is sooo close to working.

But the problem appears to be with the user privileges to create the DB. Ive spoken to the Web Hosts, and they are a little confused as to what exactly I am trying to do.

I can run SQL code, and create databases via the web admin panel, but cannot do it via PT3.

Has anyone had experience of doing this?

Is there any SQL code I can run that will create the PT3 DB automatically, so PT3 doesnt have to do it?

Any help is appreciated.

V
VincenzoMancini
 
Posts: 21
Joined: Sun Jan 27, 2008 5:43 pm

Re: Putting the DB in postgreSQL on a Web Server

Postby prajna » Fri Aug 22, 2008 11:35 am

No, but when you are using pt3, and you setup the postgresql part, it asks for username/password. Are you using the same ones that you use to login to the postgresql database via the web?

~ Thomas
[PokerTracker Support]
prajna
 
Posts: 734
Joined: Thu Apr 03, 2008 1:58 pm

Re: Putting the DB in postgreSQL on a Web Server

Postby Seitz333 » Wed Aug 27, 2008 12:48 pm

Here is one site I built that uses a PT3 database (I have another site that uses 3 more PT3 databases).

http://anteup.seitz333.com

This one and the others are for keeping track of poker leagues. Let me know what you think.

Chuck
Seitz333
 
Posts: 71
Joined: Sun Feb 24, 2008 8:14 pm

Re: Putting the DB in postgreSQL on a Web Server

Postby Seitz333 » Tue Nov 11, 2008 7:07 pm

Thought I would update this with the second site where I use the PT3 database on a web server for league statistic. It works really good.

http://chiptalk.seitz333.com

Chuck
Seitz333
 
Posts: 71
Joined: Sun Feb 24, 2008 8:14 pm

Re: Putting the DB in postgreSQL on a Web Server

Postby kraada » Tue Nov 11, 2008 7:26 pm

That's pretty neat, I'm glad to hear it's working well for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 49 guests

cron
highfalutin