Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2007
    Posts
    688

    postgresql database gone after transfer

    Transferred a domain from one cpanel server to another using whm > copy account feature, but now this error arises

    ---------------
    pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: database "udre" does not exist
    ---------------


    Found this in the copy accounts log


    Grabbing PostgreSQL databases............
    could not change directory to "/root"
    could not change directory to "/root"
    could not change directory to "/root"
    ...............
    Done
    Grabbing PostgreSQL privileges...could not change directory to "/root"
    could not change directory to "/root"
    could not change directory to "/root"
    Last edited by Calibaba; 01-09-2008 at 09:01 PM.

  2. #2
    Join Date
    Jan 2007
    Posts
    688
    Found out the user was missing from the list / assigned to db in cpanel.

    Now I get this error


    Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: database "username_dbname" does not exist in /home/user/public_html/db.php on line 6
    pg_connect error username: username
    databasename: dbname

    Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: database "dbname" does not exist in /home/user/public_html/db.php on line 16
    pg_connect error

  3. #3
    I have no idea what is "whm > copy", but you definetely had a problem with the script.
    It is obvious from the error messages, that your databse "udre" was not transfered. The simplest way to transfer the database is to create the db dump (see "pg_dump" postgress command) and restore it to the new server.
    Software Freelancer - custom software solutions

  4. #4
    Join Date
    Jan 2007
    Posts
    688
    The character sets of the database now shows in UTF8. It was a
    "EUC_JP". How do I change it to EUC_JP?

  5. #5
    The db charset (encoding) should be defined during the db creation.
    And can not be changed later.
    Software Freelancer - custom software solutions

Posting Permissions

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