Knowledgebase
postgresql database gone after transfer
Posted by Calibaba, 01-09-2008, 08:54 PM | 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.
|
Posted by Calibaba, 01-09-2008, 11:07 PM | 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
|
Posted by pavelJ, 01-10-2008, 01:39 AM | 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.
|
Posted by Calibaba, 01-10-2008, 12:15 PM | The character sets of the database now shows in UTF8. It was a
"EUC_JP". How do I change it to EUC_JP?
|
Posted by pavelJ, 01-10-2008, 12:27 PM | The db charset (encoding) should be defined during the db creation.
And can not be changed later.
|
|
Add to Favourites
Print this Article |
Also Read
Melitaweb (Views: 620)