I modified the /etc/rc.d/init.d/postgresql script to include the -i tag Email me directly if you're interested and I'll send it
You can then do a diff between mine and the original to see what I did PS this was for a RedHat7.3 machine > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Fred Laxton > Sent: Thursday, June 20, 2002 12:46 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [SL] postgres troubles > > > Well, it turned out that I had two problems. > > The first is that starting postgres from the init script > (/etc/rc.d/init.d/postgresql start) doesn't always start up postgres > properly. > > Instead, I'm running: > > postmaster -i -D /var/lib/pgsql/data > > in my /etc/rc.d/rc.local > > The error messages misled me into modifying > /var/lib/pgsql/data/pg_hba.conf. I had forgotten that the folder is > owned by user postgres, so it changed the ownership to root. The init > script did NOT report an error, while the postmaster did. > > Once I started postgres by running postmaster, and fixed ownership of > the /var/lib/pgsql/data/pg_hba.conf to belong to user postgres, SQL > Ledger started up fine. > > I still prefer MySQL, but I have learned a lot about postgres ;-) > > Fred > > On Tue, 2002-06-18 at 16:46, Fred Laxton wrote: > > It looks like my postgresql install is messed up somewhere, > now I get an > > error when I try to run > > > > [postgres@linux fred]$ psql > > > > psql: FATAL 1: No pg_hba.conf entry for host localhost, > user postgres, > > database postgres > > > > even though I'm running as user "postgres" > > > > I've tried messing with the /var/lib/pgsql/data/pg_hba.conf > file, and > > can't seem to make it work no matter what I do. > > > > After each change, I issue (as root): > > > > kill -s sighup #### > > > > where #### is the PID of the postgres postmaster... > > > > Any help would be appreciated! > > > > Thanks, > > > > Fred > > > > On Tue, 2002-06-18 at 14:01, Fred Laxton wrote: > > > I used to use SQL Ledger 1.8.2 and 1.8.3, and then I had > a hard drive > > > failure and lost my Linux root partition. This was on > Mandrake 8.0. > > > > > > I've since gotten a new drive, installed Mandrake 8.2, > and am trying to > > > get SQL Ledger 1.8.4, with the patch, up and running. > > > > > > When I try to use the PG Database Administration page > during setup, I > > > set it to: > > > > > > Host: 192.168.0.223 - IP of the machine hosting the site > > > Port: (blank) > > > User: sqlledger > > > Password: <password for postgrers user sqlledger> > > > Connect to: sqlledger > > > > > > I already created postgres user "sqlledger" using Webmin, > and created > > > database "sqlledger". > > > > > > I get message: > > > could not connect to server: Connection refused > > > > > > My /var/lib/pgsql/data/pg_hba.conf contains: > > > > > > local all trust > > > host all 192.168.0.223 255.255.255.0 trust > > > > > > Here's another error when I change the parameters: > > > > > > Host: (blank) > > > Port: (blank) > > > User: sqlledger > > > Password: <password for postgres user sqlledger> > > > Connect to: sqlledger > > > > > > FATAL 1: No pg_hba.conf entry for host localhost, user sqlledger, > > > database sqlledger > > > > > > Yet I specifically have a line in pg_hba.conf that says "local all > > > trust" which should do it. Sheesh! > > > > > > > > > One other difference with the last install I did: webmin > didn't see that > > > postgres was installed, so I had to locate the > configuration files and > > > point webmin to them. Then it was able to access > postgres and see the > > > template0 and template1 databases that were already > there, for example. > > > > > > I'm new to postgres, I find MySQL much easier to work > with - I really > > > wish SQL Ledger used MySQL instead, it's so easy to work > with ;-) Oh, > > > and PHP, too ;-) But, if I can get it working, I'll > settle for Perl > > > and Postgres... > > > > > > TIA > > > > > > Fred > > > > > > -- > > > > > > > > > -- > > > Fred Laxton > > > > > > My contact information: > > > http://infotechdesign.net/my_contact_information.htm > > > > > > Powered by Yellow Dog Linux and Mandrake Linux > > > > > > > > > > > > > -------------------------------------------------------------- > -------------- > > > Bringing you mounds of caffeinated joy > > > >>> http://thinkgeek.com/sf <<< > > > > > > _______________________________________________ > > > Listinfo https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > Archive http://www.geocrawler.com/redir-sf.php3?list=sql-ledger-users > > > -- > > > -- > Fred Laxton > > My contact information: > http://infotechdesign.net/my_contact_information.htm > > Powered by Yellow Dog Linux and Mandrake Linux > > > > -------------------------------------------------------------------------- -- > Bringing you mounds of caffeinated joy > >>> http://thinkgeek.com/sf <<< > > _______________________________________________ > Listinfo https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > Archive http://www.geocrawler.com/redir-sf.php3?list=sql-ledger-users > -- -- Fred Laxton My contact information: http://infotechdesign.net/my_contact_information.htm Powered by Yellow Dog Linux and Mandrake Linux ------------------------------------------------------- Bringing you mounds of caffeinated joy >>> http://thinkgeek.com/sf <<< _______________________________________________ sub/unsub https://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive http://www.mail-archive.com/[email protected]/ ------------------------------------------------------- Bringing you mounds of caffeinated joy >>> http://thinkgeek.com/sf <<< _______________________________________________ sub/unsub https://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive http://www.mail-archive.com/[email protected]/
