Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: Couple Questions.

    Hi. I have been checking out postgresql lately and i have a couple questions.

    #1. With a single user database that was on that users computer would security still be an issue?
    #2. What would be a good way to distribute a postgresql database(probably on mac to mac's)?

    For question #2 I was thinking of just writing an Installer that would use a script to first install a postgresql server, then move all the files into place(like the database pg_dump file) then a second script that restores the database onto the server. How does that seem?


    P.S First Post!!

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    Security is always an issue. Even with a single user database. It is less of an issue with a single user db, but, it still is an issue.

    You should ensure that the pg_hba.conf configuration file is set to disallow external access to the server.

    You should ensure that the postgres user does not have admin access to the machine.

    For question 2, The scripting approach is the usual one taken.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

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