Обсуждение: Just switched to Mac - Postgres.app or Homebrew or some other distribution?

I've been playing around with Postgres.app, and while it works well, it does hide some of the server-side stuff and
configuration.

What is the best way to run PostgreSQL on the Mac that mirrors the Linux workflow? I'm not doing anything too complex.

Thank you.

On 10/16/2022 12:23 PM, Simon Connah wrote:
> I've been playing around with Postgres.app, and while it works well, it does hide some of the server-side stuff and
configuration.
>
> What is the best way to run PostgreSQL on the Mac that mirrors the Linux workflow? I'm not doing anything too
complex.
>
> Thank you.

I used a download from Enterprisedb. Make sure you add the location of 
the  installation to the PATH because Macs come with a partial 
installation of Postgres pre-installed and you want your installation to 
be in the path so your shell commands and front-end commands (e.g., 
psql, pgAdmin, LibreOffice, etc.) will work properly.

- G

-- 
siamo arrivati sani e salvi

Thanks. I'll look into that.

As for the Docker suggestion, I should probably spend some time learning how to use it correctly, but for the time
being,I'm going down this route while I get everything up and running, and I can worry about Docker later. 

Simon.

------- Original Message -------
On Sunday, October 16th, 2022 at 18:39, Gerald Cheves <gcheves@verizon.net> wrote:


>

>

> On 10/16/2022 12:23 PM, Simon Connah wrote:
>

> > I've been playing around with Postgres.app, and while it works well, it does hide some of the server-side stuff and
configuration.
> >

> > What is the best way to run PostgreSQL on the Mac that mirrors the Linux workflow? I'm not doing anything too
complex.
> >

> > Thank you.
>

>

> I used a download from Enterprisedb. Make sure you add the location of
> the installation to the PATH because Macs come with a partial
> installation of Postgres pre-installed and you want your installation to
> be in the path so your shell commands and front-end commands (e.g.,
> psql, pgAdmin, LibreOffice, etc.) will work properly.
>

> - G
>

> --
> siamo arrivati sani e salvi
>

Hi,

Not sure why you want to run the database from a mac? Just being curious

Much better running from a server? You can get a cloud server with your 
choice of OS (I suggest Fedora or Arch) from linode for $20/month to do 
your testing? It comes with 80GB data storage. If your data needs are 
substantial and on prem server with zfs (again arch as the base system) 
will be more suitable.

Macs are great (I have been a user for decades), but they 'cripple' 
Unix, so you don't get the full advantage.

Alex Theodossis
alex@dossi.info

On 10/16/22 13:39, Gerald Cheves wrote:
> On 10/16/2022 12:23 PM, Simon Connah wrote:
>> I've been playing around with Postgres.app, and while it works well, 
>> it does hide some of the server-side stuff and configuration.
>>
>> What is the best way to run PostgreSQL on the Mac that mirrors the 
>> Linux workflow? I'm not doing anything too complex.
>>
>> Thank you.
>
> I used a download from Enterprisedb. Make sure you add the location of 
> the  installation to the PATH because Macs come with a partial 
> installation of Postgres pre-installed and you want your installation 
> to be in the path so your shell commands and front-end commands (e.g., 
> psql, pgAdmin, LibreOffice, etc.) will work properly.
>
> - G
>

> On Oct 16, 2022, at 11:23 AM, Simon Connah <simon.n.connah@protonmail.com> wrote:
>
> What is the best way to run PostgreSQL on the Mac that mirrors the Linux workflow? I'm not doing anything too
complex.


Hombebrew is a good option. I'm using it in development and production without any problems. I previously used CentOS,
anddon't find the workflow to be much different. 


John DeSoi, Ph.D.

------- Original Message -------
On Sunday, October 16th, 2022 at 21:04, Alex Theodossis <alex@dossi.info> wrote:

>

>

> Hi,
>

> Not sure why you want to run the database from a mac? Just being curious
>

> Much better running from a server? You can get a cloud server with your
> choice of OS (I suggest Fedora or Arch) from linode for $20/month to do
> your testing? It comes with 80GB data storage. If your data needs are
> substantial and on prem server with zfs (again arch as the base system)
> will be more suitable.
>

> Macs are great (I have been a user for decades), but they 'cripple'
> Unix, so you don't get the full advantage.
>

> Alex Theodossis
> alex@dossi.info
>

> On 10/16/22 13:39, Gerald Cheves wrote:
>

> > On 10/16/2022 12:23 PM, Simon Connah wrote:
> >

> > > I've been playing around with Postgres.app, and while it works well,
> > > it does hide some of the server-side stuff and configuration.
> > >

> > > What is the best way to run PostgreSQL on the Mac that mirrors the
> > > Linux workflow? I'm not doing anything too complex.
> > >

> > > Thank you.
> >

> > I used a download from Enterprisedb. Make sure you add the location of
> > the installation to the PATH because Macs come with a partial
> > installation of Postgres pre-installed and you want your installation
> > to be in the path so your shell commands and front-end commands (e.g.,
> > psql, pgAdmin, LibreOffice, etc.) will work properly.
> >

> > - G

Hi,

I'm just doing basic web development. I could use Linode (they already host a couple of blogs for me), but since I'm
stillplaying around with PostgreSQL, I'd rather just do it on my Mac for the time being.