Results 1 to 5 of 5

Thread: GUI install of postgreSQL and pgaccess: usable?

  1. #1

    Default GUI install of postgreSQL and pgaccess: usable?

    I am new to linux, am attempting to abandon microsoft because after 30 years I have had enough of being jerked around by them.

    I have used yast to install the components of Postgresql and pgAccess, including language support for Tcl/Tk.
    Starting the postgresql server is successful.

    I would like to use pgAccess as a front end to the server/databases.
    However, nothing I do seems to make pgAccess available. I can't invoke it and can't find it on a menu anywhere.

    In searching forums on this issue they all discuss compiling postgresql and pgAccess on the local machine, no one talks about how to use pgaccess whose installation was managed by a gui.

    Do I need to start over, removing everything I installed with yast, and go with the command line installs and compiles, or can I use what yast installed?
    If the latter, how do I start pgaccess? Nothing I do works.

    Thanks in advance for any help.
    Fred

  2. #2

    Default Re: GUI install of postgreSQL and pgaccess: usable?

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    Welcome to the free world. Thirty years..... wow. You're a tough-skinned
    individual.

    Just to make sure you're after the right tool, what is your end goal? If
    it's access to the database via a non-terminal I have a couple thoughts.
    First, look at pgadmin. pgaccess looks like it may be from a time when
    there were not alternatives that were as good (for example, the current
    build for the no-longer-maintained project is from 2004). pgadmin is
    something I've seen several people use and they seem to like it. Also,
    consider other tools such as DB Visualizer that work well for many
    databases (even bad ones from companies that jerk you around).

    Second, be sure you know the terminal commands eventually. It's worth it,
    though at the start a GUI is really nice for learning.

    Good luck.





    On 10/28/2010 03:06 PM, fredrated wrote:
    >
    > I am new to linux, am attempting to abandon microsoft because after 30
    > years I have had enough of being jerked around by them.
    >
    > I have used yast to install the components of Postgresql and pgAccess,
    > including language support for Tcl/Tk.
    > Starting the postgresql server is successful.
    >
    > I would like to use pgAccess as a front end to the server/databases.
    > However, nothing I do seems to make pgAccess available. I can't invoke
    > it and can't find it on a menu anywhere.
    >
    > In searching forums on this issue they all discuss compiling postgresql
    > and pgAccess on the local machine, no one talks about how to use
    > pgaccess whose installation was managed by a gui.
    >
    > Do I need to start over, removing everything I installed with yast, and
    > go with the command line installs and compiles, or can I use what yast
    > installed?
    > If the latter, how do I start pgaccess? Nothing I do works.
    >
    > Thanks in advance for any help.
    > Fred
    >
    >

    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v2.0.15 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

    iQIcBAEBAgAGBQJMyeuOAAoJEF+XTK08PnB56AcQAKQEzocYP2iYnYRweRLLTJ3k
    T1jIfT2ddULnXYQcGji3q9veCZSVU2r3s3Pav4CzW1DDDasXOZyZwS+z+U4qa9ls
    +b6S4T2h9wXT175tbRIkk+4APTT1Xiezbw4XJoyff8JLUywtsdApdxH4/9zgncSR
    H5vMmbT/yGrhs1RwhSWhHMXpAEyQKXydG07eHHNquJASL3vAI0+B6sxfPdJ4Opna
    CVrSgj+DlXCpZEnht3Fu9nOxEY3Zpgw55Jrk2WDc7nBf3fxXLb9obFCglhMXNjYL
    ZW+cfkoTrX7fzO0h0bPjaOvPVJfDoYsO0tgh8xOhSk078/asK1zsZKmlOVSCnkyl
    yn9OxLFUspr+Se1qPn08yxLL1K1Vg2Syq+7YEoSmWxfaHL+tTPYmJix8KwaJdjbf
    sndideeZ/c9cL7Vt1+yAzebJA5Noos0D766BmB8IOiyjFpI5eeONfrzwXORrW+98
    UjBq52wwvIRmNsfJ6b8c0BnX2IFrTOtE2HKBximz6fufksRbDW1VjtZzmDV5pHJd
    5nIhBIYgpQB8lThV5Jf9NdElyOVS9rhjBKhWL2AqC3v8AFisdwnOoSdxoDrXOSkP
    PJSaaQkwscC7wKiLpW1JGP3U4asNuUxNTei7DhBaluXD4IPo1II3oa+A7x7iiBsU
    M6H2+V7J6bcmXDvHvH3j
    =/Ir6
    -----END PGP SIGNATURE-----

  3. #3

    Default Re: GUI install of postgreSQL and pgaccess: usable?

    Thanks for your reply.
    The goal is to turn my machine into a personal development platform to begin learning the development tools for internet applications (yes I am late to the game but it is still early enough) and I am quite excited about turning my efforts in that direction after being almost exclusively a database developer.

    So my short term goal is
    Install postgreSQL as my database platform
    Install Apache and tomcat to become a web server
    Install Drupal, hoping that will be a suitable framework for serving up my ideas of what a web interface can be
    Develop amazing must-have web application(s)
    Profit!

    So I can't say "Back to square one!" because that is where I am stuck!

    I should mention that for now I am running suse linux inside Oracle VirtualBox on a windows XP machine.
    When I am deemed to be not dangerous, I will be runnning it in a vm on a vm cluster of linux boxes.

    Thanks for the info, I didn't realize pgaccess was so old.
    Isn't pgAdmin a web interface, so I would need to finish the latter part of my platform (web server) before I could give pgAdmin a link to the postgreSQL database?
    That would be fine, I don't need to create databases first, it just seemed like a good starting point.

    Also, can you think of any good software applications or design steps it would be good to add to my conquer-the-world scenario?
    I was thinking of javascript on the browser/python on the server, but the powers-that-be want something more common like php.
    Thanks again. Fred.

  4. #4

    Default Re: GUI install of postgreSQL and pgaccess: usable?

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    Is pgadmin a web interface? I doubt it, but Google will confirm.

    VirtualBox, neat. It's a good tool, and runs equally well on Linux (and
    probably faster because of inherent slowness in the host you've chosen
    (filesystem, etc.)).

    Not sure if Drupal works w/PostgreSQL but haven't checked and since you've
    chosen it I assume it does. PostgreSQL is great so you should be able to
    take over the world fairly easily using it with the right combination of
    tools (Apache, Linux, etc.).

    Python or PHP.... I'm biased toward PHP because I've used it a bit, but
    Python is also amazing and I know people who swear by it. I am currently
    working (as tie allows) on learning Python and so far it lives up to its
    reputation.

    Tools.... there are millions of development tools. If you go with PHP you
    may find Zend Studio is worth the price. Eclipse of course is wonderful.
    Make sure you add all of the fun WebDeveloper extensions to Firefox.
    Live HTTP Headers is also great. Firebug, I'm told, is superb.

    Good luck.





    On 10/29/2010 08:06 AM, fredrated wrote:
    >
    > Thanks for your reply.
    > The goal is to turn my machine into a personal development platform to
    > begin learning the development tools for internet applications (yes I am
    > late to the game but it is still early enough) and I am quite excited
    > about turning my efforts in that direction after being almost
    > exclusively a database developer.
    >
    > So my short term goal is
    > Install postgreSQL as my database platform
    > Install Apache and tomcat to become a web server
    > Install Drupal, hoping that will be a suitable framework for serving up
    > my ideas of what a web interface can be
    > Develop amazing must-have web application(s)
    > Profit!
    >
    > So I can't say "Back to square one!" because that is where I am stuck!
    >
    > I should mention that for now I am running suse linux inside Oracle
    > VirtualBox on a windows XP machine.
    > When I am deemed to be not dangerous, I will be runnning it in a vm on
    > a vm cluster of linux boxes.
    >
    > Thanks for the info, I didn't realize pgaccess was so old.
    > Isn't pgAdmin a web interface, so I would need to finish the latter
    > part of my platform (web server) before I could give pgAdmin a link to
    > the postgreSQL database?
    > That would be fine, I don't need to create databases first, it just
    > seemed like a good starting point.
    >
    > Also, can you think of any good software applications or design steps
    > it would be good to add to my conquer-the-world scenario?
    > I was thinking of javascript on the browser/python on the server, but
    > the powers-that-be want something more common like php.
    > Thanks again. Fred.
    >
    >

    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v2.0.15 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

    iQIcBAEBAgAGBQJMytuJAAoJEF+XTK08PnB5lpsP/RnZ2FhMsQTuAVUCodbbHpjI
    1p2cz8MCo2LwUkt6SQhhezKGmmkCcDUI70jM3bWN8UjyMa97fQf5d25l6XrDUjgC
    1N63+mQy02ihTHxXtqQei6eMdDKLc5OEjmMg6LQj8gkbSy4JQj+FxfpWN1O2Tdve
    tmJ7JZpQqoPLkyvCc4PGn07IUaYxDzMcfuWrTmkadplIkjZz/LcHmBn3HMi0wDVz
    /yvAsyiuEkX0fYYVNTvuWdi9DQFMRQ0H9aXLus99iaKtrFGhWG0On3bsONbGn+k2
    3RmqEtr9XAXG1O2U5bAaJot2yBprREAidQgh+0Kp1QwzjU8nEjmXRfuAPpiAGQPP
    MOz2E8K058KnTBz4r29PvMBhw5kPTqG5TRkJJ3VFFMCJmkwswA28SgOgluuP0e9b
    qCihl8I8sILRIXKbMQKgLwhBONci4Y/rHM+hHrFN77ut1qAren1XiQAkCF+LOhQG
    +a+I66RLgPndT5zvt1MGTZt8CIL1KmxsTMF7feKOjLrD+288Vk++Y7bi6SZEOdKQ
    7Y/7fh1RO6h2Tpoia2tZxUOGIBYJFOLk+TBcOnNPOBKoZ1/lbTXTapLxJLul1qWS
    dm5QcL8IOz4l2lCCAna//LmcIBY05exK8KS5ePDR5POs7trmn3+g7GH68qdLbTPL
    EMyv1/WizZkx4V0h6MV1
    =x18Q
    -----END PGP SIGNATURE-----

  5. #5
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,149
    Blog Entries
    2

    Default Re: GUI install of postgreSQL and pgaccess: usable?

    Cool,
    Someone talking about something related to what is on my shortlist of things "To Do."

    First, would recommend that if you're seriously interested in Drupal development to look for a Drupal UG in your area. I've tinkered with Drupal on OpenSuSE and like its flexibility and support for templating themes, I only find the module architecture a little weird and requires some getting used to.

    I've also seen some good reviews and recommendations for pgadmin and would like to see comments from anyone who might have used it to build databases(design as well as admin).

    Would also like to hear from anyone who might be able to compare pgadmin with mergeant which is a multi-database admin tool (I see the OpenSuSE RPM offers the Dev version with presumably more design features). If it's powerful enough, I just might prefer it so I don't have to install a tool for every database (I'm sorry to see knoda go with KDE 3).

    Tony

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •