Re: [cobalt-users] Is there a PostgreSQL GUI Admin for RAQ4r? (BCPower)

["Andrew Woods" <andreww@xxxxxxxxxx>]

Greetings 

I was looking for other info on Postgres relating to Cobalt and saw this
posting.
Just thought I would answer some of your questions regarding Postgres
There are actually a couple of ways to administer it.
	- psql: a command line utility 	(I use this - Recommended)
	- kpsql: a graphical utility that runs under KDE on Linux
	- pgaccess: A graphical utility written in Tcl/Tk ( which are
Linux/Unix languages)


Carrie Bartkowiak wrote:
> 
> ||>Morning all!
> 
> Morning!
> 
> ||>Is there an easy-to-use interface for administering PostgreSQL?
> ||>Heck, Does
> ||>the RAQ4r have PostgreSQL installed?  I think it does.
> 
> It does have it installed. However, I haven't been able to find *anything*
> about what the default password may be, or how to access it, etc. I've asked
> (long, long ago on the list) but was simply pointed to the PostgreSQL
> manual. Which, of course, didn't help, because *I* didn't install it on the
> machine so *I* didn't set the password.

On a default installation, there is no password. However, you have to
login is as
the user "postgres", which is the superuser for the PostgreSQL server

So heres what you do

If you dont use SSH , use Telnet. 

localhost> ssh raq.yourdomain.com -l admin (This will ask for a
password)

admin@raq> man psql   (this will show you the available options )

admin@raq> psql -l	(this will show you a list of databases and exit)

admin@raq> psql -d <database> -u
username: postgres		(this should give you access as postgres)

If the above command didn't work, then:
admin@raq> su - 

root@raq# su postgres

postgres> psql -d database
\

\?   gives a list of internal commands
\h   helps you with SQL
\d   shows a list of objects in your current database
\dt  shows a list of tables in your current database

\q   ends your  psql session

I would suggest buying the book "PostgreSQL  Introduction and Concepts"
by Bruce Momjian




> 
> ||>I would absolutely love to be able to run a FAQ Database similar to the
> ||>Cobalt Knowledgebase.  Whick coinsidentaly runs PostgreSQL.
> 
> I'm going to be watching this thread to see if someone comes up with the
> default password or a GUI to work with PostgreSQL - preferably both. Good
> luck in your search, and I hope someone knows the default password! (For
> post and for interbase...)
> 
> Carrie Bartkowiak
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users

-- 
===================================

Andrew Woods
Programmer
Animated Designs LLC 

"From Concept to Design"

mailto:andreww@xxxxxxxxxx
http://www.anides.com