• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

Trouble migrating PostgreSQL on another server


So here’s my situation. Right now, we’re working on an End of life version of LedgerSMB (ver. 1.2.21) with PostgreSQL 8.4.11 which are stored in a very old server that is running on ubuntu 10.04.4. Unfortunately, this server is about to give up on life and leave us ( :( ). So what I’ve been trying to do is to migrate this server to a new one which is running on Debian Squeeze 6.0.7 i386. Moreover there’s something I’d like to add, the old ledgersmb server was configurated by someone else who is not contactable, so at the present time I have no idea where he stored all the file. I managed to find the configuration file of ledgersmb which were located in /var/local/ledgersmb and also the PostgreSQL files which were in /var/lib/postgresql. (Am i missing some files here ?)

One of the step I’ve done was to install the LedgerSMB 1.3.23 with the PostgreSQL 8.20. From that point, some people told me to copy the configuration file as well as the data file from the old LedgerSMB to the new one. They also told me to copy the file from the old database of PostgreSQL from /var/lib/postgresql and paste it on the new one. (If this is how it should be done, why did it failed ? Or was it a step I should have done with the same version of my old server ?)

I’ve also tried to do a backup of the older server (which the database name & user’s ownership that are unknown to me) with sudo pg_dumpall >  /directory/backup. However, everytime i’ve tried to run that command on root or any other users, I received this message : Permission denied. But there’s one user named postgres which i couldn’t find its password.

So the main point is that I’m trying to migrate the old database to a new one and I’d like to have some advices because I’m about to rip my hair off!

Thanks in advance,
D. Nguyen
1 Solution
earth man2Commented:
as root you can change postgres account password.

sudo root
passwd postgres

then you can run dumpall
asusxtianAuthor Commented:
Thanks a lot! finally solved the backup issue!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now