OSX: migrating Postgres db from one Mac to another

From: Carlo Poso <carloposo(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: OSX: migrating Postgres db from one Mac to another
Date: 2021-06-24 13:44:27
Message-ID: CAFXR-WEmu+B_G0Q_NPe6-5mewMdocL-LSN2pzfHGK99TteOQ8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
my Mac unfortunately crashed. I have a Time Machine backup.
Using the Migration Assistant on a new Mac allowed me to get all my
documents back, but unfortunately Postgres is not able to start.

So I was trying to manually set-up my Postgres db.

Here are the steps:

- install a fresh copy of Postgres (v11)
- replace the /Library/PostgreSQL/11/data folder with the one I dig out
from my dead Mac, where I assume my data is stored
- check/fix owner of folders (must be 'postgres', I assume)
- start pgAdmin
- enter the PW for postgres user
- click on "PostgreSQL 11" server to show databases

This is where I have problems. I am prompted with the same pop-up asking me
to enter the password for the user 'postgres'. I type it and I get the
following:
[image: Screen Shot 2021-06-24 at 15.25.03.png]

*Carlo*

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sándor Daku 2021-06-24 13:45:16 Re: insert ..... returning <column> problem
Previous Message Marc Mamin 2021-06-24 13:29:38 RE: removing "serial" from table definitions.