Go Premium for a chance to win a PS4. Enter to Win


Trouble migrating PostgreSQL on another server

Posted on 2014-03-11
Medium Priority
Last Modified: 2014-03-12

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
Question by:asusxtian
LVL 22

Accepted Solution

earth man2 earned 2000 total points
ID: 39923342
as root you can change postgres account password.

sudo root
passwd postgres

then you can run dumpall

Author Comment

ID: 39923510
Thanks a lot! finally solved the backup issue!

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Screencast - Getting to Know the Pipeline

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question