Re: OSX: migrating Postgres db from one Mac to another

From: Carlo Poso <carloposo(at)gmail(dot)com>
To: Дмитрий Иванов <firstdismay(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: OSX: migrating Postgres db from one Mac to another
Date: 2021-06-24 14:15:31
Message-ID: CAFXR-WHtVHkfPWOJhTX+1HGwmP0+Q4vVO-tgDsKEdAAUt+1oSg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks.
The message I get after entering the PW is "could not connect to server:
Connection refused Is the server
running on host "localhost" (::1) and accepting TCP/IP connections on port
5432? could not connect to server: Connection refused Is the server running
on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port
5432?"

*Carlo*

Il giorno gio 24 giu 2021 alle ore 15:55 Дмитрий Иванов <
firstdismay(at)gmail(dot)com> ha scritto:

> # -*- coding: utf-8 -*-
>
> ##########################################################################
> #
> # pgAdmin 4 - PostgreSQL Tools
> #
> # Copyright (C) 2013 - 2021, The pgAdmin Development Team
> # This software is released under the PostgreSQL Licence
> #
> # config.py - Core application configuration settings
> #
> ##########################################################################
> .........
> ##########################################################################
> # Master password is used to encrypt/decrypt saved server passwords
> # Applicable for desktop mode only
> ##########################################################################
> MASTER_PASSWORD_REQUIRED = True -> False
>
>
>
> чт, 24 июн. 2021 г. в 18:44, Carlo Poso <carloposo(at)gmail(dot)com>:
>
>> 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*
>>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-06-24 14:19:17 Re: removing "serial" from table definitions.
Previous Message Laurenz Albe 2021-06-24 14:13:54 Re: insert ..... returning <column> problem