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*
>>
>
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 |