pqsql database error after server move

I moved an account that uses pgsql databases from server A to server B.

Now that it's on server B - the script DOES connect to the database, however it's throwing all sorts of permissions errors n such:

Warning: pg_query(): Query failed: ERROR: tblnotes: permission denied in /home/usr/public_html/zelrik/inc/notes.inc on line 35

Warning: pg_fetch_assoc(): supplied argument is not a valid PostgreSQL result resource in /home/usr/public_html/zelrik/inc/notes.inc on line 36

Warning: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in /home/usr/public_html/zelrik/inc/notes.inc on line 59
Those are just a few examples.
It's the same version of pgsql running on both servers...
All files and directories have the same ownerships/permissions as when they were on the old server..

The only odd thing was that cPanel didn't transfer over the sql database - so I had to make a dump via root shell on server A and restore via root shell on server B.

So... any ideas?

 

 

 

 

Top