phpmyadmin type thing for postgre?

[Michael Holden]

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 ***@postgresql.org)

[Bryan Encina]

Michael,

Post by Michael Holden
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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Steve Lane]

There's something very much like that: phpPgAdmin.

http://phppgadmin.sourceforge.net/

:-)

-- sgl

Date: Tue, 22 Jun 2004 10:09:42 -0700
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Graham Clarke]

Yup -- phpPgAdmin -- you can find it on sourceforge.net

also look on the PG site for others

cheers
graham

Post by Michael Holden
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

Graham Clarke
***@53Tech.com
www.53Tech.com
603.643.9955



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Janio Rosa da Silva]

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

[Steve Lane]

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

Date: Wed, 23 Jun 2004 01:38:44 -0300
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Grega Bremec]

Post by Janio Rosa da Silva
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]

Post by Grega Bremec
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,