Thread: phpmyadmin type thing for postgre?
Hey folks.... Just getting into postgre now. I am wondering if there is something like PhpMyAdmin (web-based db admin tool) for postgresql. Any help is much appreciated! Thanks loads, Michael
Michael, > Hey folks.... > > Just getting into postgre now. I am wondering if there is something > like PhpMyAdmin (web-based db admin tool) for postgresql. Any help is > much appreciated! There's phppgadmin which you can find at: http://sourceforge.net/projects/phppgadmin/ -b
There's something very much like that: phpPgAdmin. http://phppgadmin.sourceforge.net/ :-) -- sgl > From: Michael Holden <michael@superpod.com> > Date: Tue, 22 Jun 2004 10:09:42 -0700 > To: pgsql-admin@postgresql.org > Subject: [ADMIN] phpmyadmin type thing for postgre? > > > Hey folks.... > > Just getting into postgre now. I am wondering if there is something > like PhpMyAdmin (web-based db admin tool) for postgresql. Any help is > much appreciated! > > Thanks loads, > > Michael > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
Yup -- phpPgAdmin -- you can find it on sourceforge.net also look on the PG site for others cheers graham At 10:09 AM 6/22/2004, Michael Holden wrote: >Hey folks.... > >Just getting into postgre now. I am wondering if there is something like >PhpMyAdmin (web-based db admin tool) for postgresql. Any help is much >appreciated! > >Thanks loads, > >Michael > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) Graham Clarke GrahamC@53Tech.com www.53Tech.com 603.643.9955
I am looking for a way to start PostgreSQL when the computer is turned on. Any ideas? I am using Slackware 9.1 and PostgreSQL 7.4.2; I was made a rc.postgresql script file. And I called for it from rc.local. But, I thing when the slackware is starting, the commands in script file are executting under root. But the pg_ctl or postmaster should be executed under the postgres user. Who can I start the postgresql server when the slackware is turned on? thanks, Janio
Janio: My experience of various Linux distributions is not very wide. But I'd be surprised if slackware didn't have some variant of the su -c command, which is what I generally use to start postgres from rc.* scripts. A line like su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data &" usually does it for me. Sorry if this is obvious and I'm missing the point. -- sgl > From: "Janio Rosa da Silva" <janio_2003@yahoo.com.br> > Date: Wed, 23 Jun 2004 01:38:44 -0300 > To: <pgsql-admin@postgresql.org> > Subject: [ADMIN] PostgreSQL With Slackware > > > I am looking for a way to start PostgreSQL when the computer is turned > on. Any ideas? > > I am using Slackware 9.1 and PostgreSQL 7.4.2; > > I was made a rc.postgresql script file. And I called for it from rc.local. > > But, I thing when the slackware is starting, the commands in script file are > executting under root. But the pg_ctl or postmaster should be executed under > the postgres user. > > Who can I start the postgresql server when the slackware is turned on? > > thanks, > > Janio > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >
...and on Wed, Jun 23, 2004 at 01:38:44AM -0300, Janio Rosa da Silva used the keyboard:
>
> I am looking for a way to start PostgreSQL when the computer is turned
> on. Any ideas?
>
> I am using Slackware 9.1 and PostgreSQL 7.4.2;
>
> I was made a rc.postgresql script file. And I called for it from rc.local.
>
> But, I thing when the slackware is starting, the commands in script file are
> executting under root. But the pg_ctl or postmaster should be executed under
> the postgres user.
>
> Who can I start the postgresql server when the slackware is turned on?
>
> thanks,
>
> Janio
Hello,
We have a couple of setups running PostgreSQL, all based on Slackware,
various versions.
I don't know if you're aware of it, but Slackware init had been a lot more
sysv-like since 8.0 already. The only thing missing are init.d and rc?.d
directories in /etc/rc.d; if you create these and put things inside, the
rc scripts will automatically pick it up and do the right thing [tm]. Well,
almost.
That said, you can use the contrib/start-scripts/linux script to control
PostgreSQL, which will also switch the identity when starting up postmaster,
all you need is to modify it a bit if you installed under a prefix other
than /usr/local/pgsql/.
Two notes though:
- you will need to patch the /etc/rc.d/rc.sysvinit script, as it
currently does kill scripts in a wrong manner - instead of
executing kill scripts for the target runlevel, it executes them
for the originating runlevel, which is wrong. Then again, it's no
biggie, as all you need to change is in the attached patch
- I've done some modifications to contrib/start-scripts/linux that
will also source a file containing environment variables for extra
data directories, so there's no need for manual modifications of
runtime environment to make postmaster realize there are other
locations for databases - all you need is add an environment
variable to that file; the attached script is the modified one,
but do look into ${prefix}, ${PGDATA} and ${PGLOG} - they most
probably don't contain the values you want
Recap - patch /etc/rc.d/rc.sysvinit with the attached patch, create
$ mkdir /etc/rc.d/{init,rc{0,1,2,3,4,5,6}}.d
put the attached postgres script into /etc/rc.d/init.d/ and create
symlinks in appropriate runlevel directories. If you'd like to use
extra data directoeis, put the attached data_dirs file into postgres
home directory. After you've done that, everything should go smoothly
on startup.
(Hopefully the patches go through to the list, if not and anybody is
interested, e-mail me and I'll send them to you too.)
Hope this helped,
--
Grega Bremec
Senior Administrator
Noviforum Ltd., Software & Media
http://www.noviforum.si/
Attachment
...and on Wed, Jun 23, 2004 at 08:53:01AM +0200, Grega Bremec used the keyboard:
>
> Recap - patch /etc/rc.d/rc.sysvinit with the attached patch, create
>
> $ mkdir /etc/rc.d/{init,rc{0,1,2,3,4,5,6}}.d
Eeek, seems there's been a mismatch in the original source file
I used to create the patch... It should go as follows:
----CUT-HERE----
--- rc.sysvinit-old 2004-06-23 09:44:24.000000000 +0200
+++ rc.sysvinit-new 2004-06-23 09:44:51.000000000 +0200
@@ -40,14 +40,15 @@
export prevlevel
fi
-# Run kill scripts in the previous runlevel if not "none"
-if [ ! "$prevlevel" = "N" ]; then
- for script in /etc/rc.d/rc$prevlevel.d/K* ; do
- if [ -x $script ]; then
- startup $script stop
- fi
- done
+# Run kill scripts
+if [ "$runlevel" = "S" ]; then
+ runlevel=1
fi
+for script in /etc/rc.d/rc$runlevel.d/K* ; do
+ if [ -x $script ]; then
+ startup $script stop
+ fi
+done
# Now do the startup scripts:
for script in /etc/rc.d/rc$runlevel.d/S* ; do
----CUT-HERE----
My sincere apologies for the mixup.
Cheers,
--
Grega Bremec
Senior Administrator
Noviforum Ltd., Software & Media
http://www.noviforum.si/