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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carlo Poso <carloposo(at)gmail(dot)com>
Cc: Дмитрий Иванов <firstdismay(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: OSX: migrating Postgres db from one Mac to another
Date: 2021-06-24 14:31:50
Message-ID: 2621427.1624545110@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Carlo Poso <carloposo(at)gmail(dot)com> writes:
> 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?"

So the step you missed is "start the Postgres server". On OSX
that's usually done by setting up a LaunchDaemon script, IIRC
(it's been awhile since I messed with that).

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-06-24 14:32:22 Re: OSX: migrating Postgres db from one Mac to another
Previous Message Michael Ivanov 2021-06-24 14:29:22 Re: insert ..... returning <column> problem