Thread: Installation "baby" steps (next steps)?
Hi everybody. Just getting started and I'm at the point after configuring and make installation of both the odbc and jdbc drivers. Both installed with no problems. Now what to do? What should be my next steps (commands) be? For testing? Against/with other apps? Is there some universal php script I can use to test postgre with? thanks! __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
You didn't mention what OS you are on. However, the executable program "psql" comes with postgres and allows you to interact with the database. Sean On 7/25/06 21:48, "julian howard" <julianhwrd@yahoo.com> wrote: > Hi everybody. Just getting started and I'm at the > point after configuring and make installation of both > the odbc and jdbc drivers. Both installed with no > problems. Now what to do? What should be my next steps > (commands) be? For testing? Against/with other apps? > > Is there some universal php script I can use to test > postgre with? > > thanks! > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend
Now what to do? What should be my next steps > (commands) be? For testing? Against/with other apps? > > Is there some universal php script I can use to test > postgre with? I assume you've install postgresql on windows. If this is the case, you probably installed pgaminIII along with it. So the first thing that I would try is to see if you can connect to postgresql using pgaminIII. If you cant you may need to take another look at your pg_hba.conf file to insure that it is configured correctly. You could preform a similar test using PHPgadmin. However, you will need to install it and run it on a web server. If all else fails, you should be able to connect to postgresql at the command line using the psql client utility. Regards, Richard Broersma Jr.
So, psql is the only thing that is installed by default. You can read the documentation about how to use it. The other option is to download the pgAdminIII program (google will get you the site). Sean On 7/25/06 22:15, "julian howard" <julianhwrd@yahoo.com> wrote: > Thanks. I'm running Mac OS X Tiger. > > --- Sean Davis <sdavis2@mail.nih.gov> wrote: > >> You didn't mention what OS you are on. However, the >> executable program >> "psql" comes with postgres and allows you to >> interact with the database. >> >> Sean >> >> >> On 7/25/06 21:48, "julian howard" >> <julianhwrd@yahoo.com> wrote: >> >>> Hi everybody. Just getting started and I'm at the >>> point after configuring and make installation of >> both >>> the odbc and jdbc drivers. Both installed with no >>> problems. Now what to do? What should be my next >> steps >>> (commands) be? For testing? Against/with other >> apps? >>> >>> Is there some universal php script I can use to >> test >>> postgre with? >>> >>> thanks! >>> >>> __________________________________________________ >>> Do You Yahoo!? >>> Tired of spam? Yahoo! Mail has the best spam >> protection around >>> http://mail.yahoo.com >>> >>> ---------------------------(end of >> broadcast)--------------------------- >>> TIP 6: explain analyze is your friend >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 4: Have you searched our list archives? >> >> http://archives.postgresql.org >> > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com
> Hi everybody. Just getting started and I'm at the > point after configuring and make installation of > both > the odbc and jdbc drivers. Both installed with no > problems. Now what to do? What should be my next > steps > (commands) be? For testing? Against/with other apps? > > Is there some universal php script I can use to test > postgre with? > > thanks! Julian, you may the postresql pdf found here: http://www.geocities.com/operationsengineer1/ helpful. it is set up for winxp, but the basics are the same for linux. use pgadmin3 to interact with your db in a visual way and then you start using commandline options as you get comfortable. as a side not - when i first tried to install pgsql 8.0, i didn't know how to use pgadmin3 and i didn't see a tutorial anywhere. i then spent the next 30 days getting pgsql 7.x set up using cygwin (must've installed and reinstalled cygwin 20-30 times, too - i was a total newb). at the end of the day, instructions to complete the tasks couldn't be found anywhere on the net (at least not all in one place). here a little, there a little. now that i know how to do it... easy pickins. good luck. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com