Thread: I can't even get started..... HELP!!!
Ok, I went into the "ports" directory and dowloaded what I thought was
PostGreSQL.
1. Ok, we downloaded and un-tared the postgresql on our new virgin
FreeBSD system.
2. Result of which, put the following files in this directory.
/usr/local/pgsql
3. An 'ls" of this directory yeilds:
.profile include post-install-notes
bin lib
data man
4. The file "post-install-notes" says to run the script...
$PREFIX/etc/rc.d/pgsql.sh start
5. I've done that, and get:
PREFIX: Undefined variable.
And I'm dead in the water.... HELP?
So I read the docs on the site to figure out whats going on, and is
says that
I have to run "postmaster"
I'm running as root, and so I go into....
/usr/local/pgsql/bin
And sure enough, there it is....
createdb dropuser pg_ctl pg_passwd psql
createlang ecpg pg_dump pg_upgrade vacuumdb
createuser initdb pg_dumpall pg_version
dropdb initlocation pg_encoding postgres
droplang ipcclean pg_id postmaster
I type: postmaster
But get:
postmaster: Command not found.
WTF!!!
Ok, so I read further that is says I have to create a superuser, but
it doesn't say in what order
I'm to do these things...
I was lead into this by reading (WHAT I BELIEVED) to be the very first
document I should
read.
From this point on, NO MATTER WHAT I do, to follow the docs,
NOTHING AT ALL
indicates Ive done ANYTHING RIGHT.
It is clear I'm missing some vital steps here....
So, could someone please PAGE me on ICQ at 5310192.. I show up as
OFF-LINE
If you don't have ICQ, mail me anyway, and I'll mail you back the
details on how to
get on our private IRC server, so someone can "hold me by the hand" to
get me started.
It is clear that I do NOT have the experience to do this by myself.
I cannot access any of the "public" IRC servers because I'm banned
because my irc clients
doesn't so some stupid "identd", so I'm deprived of even getting access
to instant or on-line
help.
John
>Simplest thing to do; forget the ports collection. The installation
>instructions available on postgresql.org are excellent, and it goes very
>smoothly on a FreeBSD box.
>
>Postgres is a fine RDBMS, I think you'll agree that it was worth the
>install :)
Thanx to Dr Vague, who paged me on ICQ, and very patiently held my
hand through this complex procedure, because I un-knowingly used the
Ports collection, he saved the day. Here is what transpired...
Bear in mind, I'm running FreeBSD, a fresh install... did the "Ports"
install, but for those that stumbled down the same path I took, here is
ALSO what you have to do.
-----------
Notes in Installing and Setting up PostGreSQL.
----------------------------------------------
1. Do the "ports" installation. It should then create a directory
/usr/local/pgsql
2. It already created the "pgsql" user, but it created the user with
no "shell" command, so we have to edit the /etc/passwd file so
this line looks like this. First, go into "root" before editing
it.
3. Edit the entry to look like this:
pgsql:*:89:89::0:0:PostgreSQL Daemon:/usr/local/pgsql:/bin/sh
NOTE: The stupid installer fucked up and set the account so
there is no login.
Use: "vipw" to edit the password file.
4. From "root" type in: su -l pgsql - this logs you into the
"pgsql" account, from which all other actions can take place.
5. Type: pg_ctl -w start - This starts the postmaster Daemon.
this runs a script that starts the postmaster.
6. If, for some problem, the machine goes down "dirty" or something
failed, after restarting again.
there is a file in /tmp called .s.PGSQL-5432 or something similar...
you have to remove that file before the postmaster can be restarted
again.
7. psql template1 - should now start up PostGreSQL, using this as a
default database.
Thanx a lot everyone.... I'll stay in here a few days to catch any other
"gotchas" that might be posted.
John
Whoa! One thing at a time... PREFIX is an internal variable used in the ports makefiles to set where exactly something gets installed. Usually, replace that with "/usr/local". So what do you get when you run the start script? /usr/local/etc/rc.d/pgsql.sh start Just typing "postmaster" at the command prompt won't do you any good until you set your shell's PATH variable to include the directory /usr/local/pgsql/bin Pay attention also to the command line options you may need with postmaster. If none of the above made sense, step back and learn the Unix command line environment first before playing around as root. Patience is rewarded because the stuff does work -- you just need to understand how. Ciao --Louis <louis@bertrandtech.on.ca> Louis Bertrand http://www.bertrandtech.on.ca/ Bertrand Technical Services, Bowmanville, ON, Canada Tel: +1.905.623.1500 Fax: +1.905.623.3852 OpenBSD: Secure by default. http://www.openbsd.org/ On Sun, 4 Mar 2001, John Draper wrote: > Ok, I went into the "ports" directory and dowloaded what I thought was > PostGreSQL. > > 1. Ok, we downloaded and un-tared the postgresql on our new virgin > FreeBSD system. > > 2. Result of which, put the following files in this directory. > > /usr/local/pgsql > > 3. An 'ls" of this directory yeilds: > > .profile include post-install-notes > bin lib > data man > > 4. The file "post-install-notes" says to run the script... > > $PREFIX/etc/rc.d/pgsql.sh start > > 5. I've done that, and get: > > PREFIX: Undefined variable. > > And I'm dead in the water.... HELP? > > So I read the docs on the site to figure out whats going on, and is > says that > I have to run "postmaster" > > I'm running as root, and so I go into.... > > /usr/local/pgsql/bin > > And sure enough, there it is.... > > createdb dropuser pg_ctl pg_passwd psql > createlang ecpg pg_dump pg_upgrade vacuumdb > > createuser initdb pg_dumpall pg_version > dropdb initlocation pg_encoding postgres > droplang ipcclean pg_id postmaster > > I type: postmaster > But get: > > postmaster: Command not found. > > WTF!!! > > Ok, so I read further that is says I have to create a superuser, but > it doesn't say in what order > I'm to do these things... > > I was lead into this by reading (WHAT I BELIEVED) to be the very first > document I should > read. > > >From this point on, NO MATTER WHAT I do, to follow the docs, > NOTHING AT ALL > indicates Ive done ANYTHING RIGHT. > > It is clear I'm missing some vital steps here.... > > So, could someone please PAGE me on ICQ at 5310192.. I show up as > OFF-LINE > If you don't have ICQ, mail me anyway, and I'll mail you back the > details on how to > get on our private IRC server, so someone can "hold me by the hand" to > get me started. > > It is clear that I do NOT have the experience to do this by myself. > > I cannot access any of the "public" IRC servers because I'm banned > because my irc clients > doesn't so some stupid "identd", so I'm deprived of even getting access > to instant or on-line > help. > > John > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
>*snip* >> >> pgsql:*:89:89::0:0:PostgreSQL Daemon:/usr/local/pgsql:/bin/sh >> >> NOTE: The stupid installer fucked up and set the account so >> there is no login. > >Um, this is a family list, sport. well - I better keep our sys admin off this list.... his gulgar language is every other word - I think I've been around him too much. >I don't care, but you risk offending somebody important. >Just a "gotcha". Point taken. > >Say, maybe we (or you, or I) could turn this into a tutorial somewhere, >eh? Kind of a "feed the world" sort of thing. Well - I outlined it in this posting, to let everyone know I was helped quite well, and to thank everyone and of course making sure others have the solution. But a tutorial sounds like a very good idea, but don't look at me, I'm very new to this. But would sure appreciate a tutorial... one for each platform, or groups of platforms. John
Hey I've done a "basic" tutorial (well it covers php, apache, postgresql for linux)... http://designmagick.50megs.com/postgresql-tutorial/ I'm hopefully going to turn this into a whole site on using this stuff.. volunteers for articles / tutorials / hints / tips welcome :) > >Say, maybe we (or you, or I) could turn this into a tutorial somewhere, > >eh? Kind of a "feed the world" sort of thing. > >Well - I outlined it in this posting, to let everyone know I was helped >quite well, and to thank everyone and of course making sure others have >the solution. > >But a tutorial sounds like a very good idea, but don't look at me, I'm >very new to this. But would sure appreciate a tutorial... one for each >platform, or groups of platforms. What platform? I must've missed the other post about this.. ------------------------ Chris Smith http://www.squiz.net
My page doesn't touch graphics, it was a basic install for apache, php, & postgres.. that's it. If you want to add extra stuff that's up to you, but the info isn't there to help you, you have to do that on your own. :) >I struggled with the 50megs version for 4 days, and couldn't get GD to >produce pngs. Apachetoolbox was my answer. It installed everything I >needed. > >Advice: >Even if you are running the latest Apache and PHP, do the whole install. >I jumped to fast and tried PHP, before I did the Apache install (over the >same version already installed, and I couldn't get GD to work), but after >I did the Apache install everything was fine. The only caveat is jpeg >aren't being produced, but Brian at Apachetoolbox is looking into it. ------------------------ Chris Smith http://www.squiz.net
I struggled with the 50megs version for 4 days, and couldn't get GD to produce pngs. Apachetoolbox was my answer. It installed everything I needed. Advice: Even if you are running the latest Apache and PHP, do the whole install. I jumped to fast and tried PHP, before I did the Apache install (over the same version already installed, and I couldn't get GD to work), but after I did the Apache install everything was fine. The only caveat is jpeg aren't being produced, but Brian at Apachetoolbox is looking into it. On Tue, 6 Mar 2001, Chris wrote: > Hey > > I've done a "basic" tutorial (well it covers php, apache, postgresql for > linux)... > > http://designmagick.50megs.com/postgresql-tutorial/ > > I'm hopefully going to turn this into a whole site on using this stuff.. > volunteers for articles / tutorials / hints / tips welcome :) > > > >Say, maybe we (or you, or I) could turn this into a tutorial somewhere, > > >eh? Kind of a "feed the world" sort of thing. > > > >Well - I outlined it in this posting, to let everyone know I was helped > >quite well, and to thank everyone and of course making sure others have > >the solution. > > > >But a tutorial sounds like a very good idea, but don't look at me, I'm > >very new to this. But would sure appreciate a tutorial... one for each > >platform, or groups of platforms. > > What platform? I must've missed the other post about this.. > > > ------------------------ > Chris Smith > http://www.squiz.net > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- R. Paul Warriner -------------------------- paulw@wzrd.com http://warriner.wzrd.com/~paulw Linux user #37729