Обсуждение: Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2
Ok, I went and bought Mandrake Linux 9.0 today, it has Postgresql 7.2. Where is Postgresql in this OS? I can see it via ps -ef|grep post*, and when it loads up on boot and stops when it shuts down. But I can't find the icon or where it resides in the GUI to start/run or use it. Help! Thanks, Jay Jay Quinn - Sr. Data Analyst Enterprise Data Warehouse http://edw.sbc.com/ http://esis.sbc.com Desk (214) 576-7163 > "This e-mail and any files transmitted with it are the property of SBC, > are confidential, and are intended solely for the use of the individual or > entity to whom this e-mail is addressed. If you are not one of the named > recipient(s) or otherwise have reason to believe that you have received > this message in error, please notify the sender at (214) 576-7163 and > delete this message immediately from your computer. Any other use, > retention, dissemination, forwarding, printing, or copying of this e-mail > is strictly prohibited." >
Hi Jay, There are a bunch of GUI options for PostgreSQL, it just depends on what you're after. The PostgreSQL 7.2 stuff that comes with Mandrake 9.0 is probably best described as the pure "database engine" that runs in the background. The part that just holds data, processes it, etc. Whilst you can do stuff with the database engine directly from applications, and from the command-line utilities that it comes with, if you're used to using a GUI then it might be best to grab one and install it. So, the next question is, any idea what you're looking to do with the GUI, so we can recommend one that does that? :-) Regards and best wishes, Justin Clift "QUINN, JAY (SBCSI)" wrote: > > Ok, I went and bought Mandrake Linux 9.0 today, it has Postgresql 7.2. > Where is Postgresql in this OS? I can see it via ps -ef|grep post*, and > when it loads up on boot and stops when it shuts down. But I can't find the > icon or where it resides in the GUI to start/run or use it. Help! Thanks, > Jay > > Jay Quinn - Sr. Data Analyst > Enterprise Data Warehouse > http://edw.sbc.com/ > http://esis.sbc.com > Desk (214) 576-7163 > > > "This e-mail and any files transmitted with it are the property of SBC, > > are confidential, and are intended solely for the use of the individual or > > entity to whom this e-mail is addressed. If you are not one of the named > > recipient(s) or otherwise have reason to believe that you have received > > this message in error, please notify the sender at (214) 576-7163 and > > delete this message immediately from your computer. Any other use, > > retention, dissemination, forwarding, printing, or copying of this e-mail > > is strictly prohibited." > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
On Wednesday 20 November 2002 23:59, Justin Clift wrote: > There are a bunch of GUI options for PostgreSQL, it just depends on what > you're after. As to GUI's, there are a couple of closed-source options available from theKompany: Rekall, and DataArchitect. Rekall is a front-end package with full scripting in python -- something like Access. DataArchitect is a designers tool -- it does ERD design work, and can reverse-engineer to an ERD from a database. While Rekall is closed source, you get the source under a distribution-restricted license. DataArchitect is traditional commercial software. Both work on Win32 and Linux. www.thekompany.com -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Install the postgresql-tk rpm. This installs the pgAccess application which you will find in the K menu (assuming KDE) under Applications/Database. On Wed, 2002-11-20 at 23:31, QUINN, JAY (SBCSI) wrote: > Ok, I went and bought Mandrake Linux 9.0 today, it has Postgresql 7.2. > Where is Postgresql in this OS? I can see it via ps -ef|grep post*, and > when it loads up on boot and stops when it shuts down. But I can't find the > icon or where it resides in the GUI to start/run or use it. Help! Thanks, > Jay > > Jay Quinn - Sr. Data Analyst > Enterprise Data Warehouse > http://edw.sbc.com/ > http://esis.sbc.com > Desk (214) 576-7163 > > > "This e-mail and any files transmitted with it are the property of SBC, > > are confidential, and are intended solely for the use of the individual or > > entity to whom this e-mail is addressed. If you are not one of the named > > recipient(s) or otherwise have reason to believe that you have received > > this message in error, please notify the sender at (214) 576-7163 and > > delete this message immediately from your computer. Any other use, > > retention, dissemination, forwarding, printing, or copying of this e-mail > > is strictly prohibited." > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Are there any freebies out there? -----Original Message----- From: Lamar Owen [mailto:lamar.owen@wgcr.org] Sent: Wednesday, November 20, 2002 11:30 PM To: Justin Clift; QUINN, JAY (SBCSI) Cc: 'pgsql-general@postgresql.org' Subject: Re: [GENERAL] Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2 On Wednesday 20 November 2002 23:59, Justin Clift wrote: > There are a bunch of GUI options for PostgreSQL, it just depends on what > you're after. As to GUI's, there are a couple of closed-source options available from theKompany: Rekall, and DataArchitect. Rekall is a front-end package with full scripting in python -- something like Access. DataArchitect is a designers tool -- it does ERD design work, and can reverse-engineer to an ERD from a database. While Rekall is closed source, you get the source under a distribution-restricted license. DataArchitect is traditional commercial software. Both work on Win32 and Linux. www.thekompany.com -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
On Wed, 20 Nov 2002, QUINN, JAY (SBCSI) wrote: > Ok, I went and bought Mandrake Linux 9.0 today, it has Postgresql 7.2. > Where is Postgresql in this OS? I can see it via ps -ef|grep post*, and > when it loads up on boot and stops when it shuts down. But I can't find the > icon or where it resides in the GUI to start/run or use it. Help! Thanks, > Jay > > Jay Quinn - Sr. Data Analyst > Enterprise Data Warehouse > http://edw.sbc.com/ > http://esis.sbc.com > Desk (214) 576-7163 > > > "This e-mail and any files transmitted with it are the property of SBC, > > are confidential, and are intended solely for the use of the individual or > > entity to whom this e-mail is addressed. If you are not one of the named > > recipient(s) or otherwise have reason to believe that you have received > > this message in error, please notify the sender at (214) 576-7163 and > > delete this message immediately from your computer. Any other use, > > retention, dissemination, forwarding, printing, or copying of this e-mail > > is strictly prohibited." before you go off looking for a fancy GUI (there are a few, pgaccess, pgadminII, etc...) try using psql from the command line. It's one of the finest command line interfaces I've seen for any database, and it's quite easy to learn.
> before you go off looking for a fancy GUI (there are a few, pgaccess, > pgadminII, etc...) try using psql from the command line. It's one of the > finest command line interfaces I've seen for any database, and it's quite > easy to learn. I agree that the command line psql is really easy, and the readline support is very nice. Don't know what that means? try entering some commands then hit the up arrow key. As for a gui, I reccomend phppgadmin, although setting it up is a little more complex, since it involves setting up a web server and php, but it is pretty nice. pgaccess is pretty straightforward and easy to use as well.
I also think as a DBA or DB Power user you got to learn a command line version of something..... Consider the following basic feature.... psql -c "some SQL query" You can now put a simple script around it for ad hoc programming and tools dev... in 20 seconds or less.... Brian Minton wrote: > >> before you go off looking for a fancy GUI (there are a few, pgaccess, >> pgadminII, etc...) try using psql from the command line. It's one of >> the finest command line interfaces I've seen for any database, and >> it's quite easy to learn. > > > I agree that the command line psql is really easy, and the readline > support is very nice. Don't know what that means? try entering some > commands then hit the up arrow key. As for a gui, I reccomend > phppgadmin, although setting it up is a little more complex, since it > involves setting up a web server and php, but it is pretty nice. > pgaccess is pretty straightforward and easy to use as well. > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org