Thread: new to Linux & Postgresql
Hello,
I am new to Linux and Postgresql. I would like to start a database and on installation of Red Hat 7.2 installed SQL server which is Postgres. I do not know where to go from here. I have taken some classes in using SQL usually at the prompt in class I would type "psql myname" and was able to start creating tables. However this is not the case here and I am not sure what to set up or how to get my server going. Can someone please help? Thank you!
RF
On Wed, 17 Jul 2002, Robb Fenwick wrote: > I am new to Linux and Postgresql. I would like to start a database and > on installation of Red Hat 7.2 installed SQL server which is Postgres. > I do not know where to go from here. I have taken some classes in > using SQL usually at the prompt in class I would type "psql myname" > and was able to start creating tables. However this is not the case > here and I am not sure what to set up or how to get my server going. > Can someone please help? Thank you! Is the server running (do a ps and look for postmaster) and what error do you get when you try to run psql?
I recommend that you buy the rather excellent book "DBA's guide to databases on Linux" published by Syngress written by David Egan and Paul Zikopoulos ISBN: 1-928994-04-0 It covers PG setup on Linux and loads of other handy things (it also covers a large number of other DBs, both commercial and OpenSource). Then, combine that with the notes on http://www.postgres.org and you are away! Oh, and use http://www.google.com to search for solutoins to any problems that you have because with OpenSource, someone, somewhere out there has usually had the same problem as you and solved it. OpenSource software comes with the best (and free) support possible for a software app and it's all online! Brad Robb Fenwick wrote: > Hello, > > > > I am new to Linux and Postgresql. I would like to start a database and > on installation of Red Hat 7.2 installed SQL server which is Postgres. I > do not know where to go from here. I have taken some classes in using > SQL usually at the prompt in class I would type "psql myname" and was > able to start creating tables. However this is not the case here and I > am not sure what to set up or how to get my server going. Can someone > please help? Thank you! > > > > RF >