Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2014
    Posts
    1

    Question Unanswered: Finding PSQL master password

    I have a client with a custom-written "accounting system" using PSQL 10. The developer is no longer in business, and all attempts to locate him or someone who might know him have been in vain.

    The application needs additional queries and I suspect the data has been corrupted (because some functions that used to work don't work now).

    I have tried to view the underlying database with a SQL tool I have used for years. But it won't let me connect to any tables in the database without a user name and password.

    Is there any inexpensive tool that will let me find the existing login credentials, so I don't damage the application's access to the database?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd create a new Pervasive server and restore the backups onto it.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    By default, a PSQL database does not have a password. If a password was placed on the file(s), only the developer would know it.
    If you have access to the source you should be able to find the password.
    What errors are you seeing?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Tags for this Thread

Posting Permissions

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