Обсуждение: 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/

...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/