I used to have PostgreSQL@14 server running on my OSX 10.11.6 machine but just discovered lately that it is no longer working. When I tried to reinstall it, it always exit with error when installing dependency package icu4c@76... the closest icu4c I can compile on that machine is @74, how can I get around and get PostgreSQL to work again? Thanks in advance for any tips/hacks. ( note: I've tried '--no-dependency' HOMEBREW_NO_INSTALL_FROM_API brew developer off etc etc but to no avail... my plan is perhaps to downgrade brew version to an older one so that those switches might work in old fashion... any downside of my plan? 2nd plan is to try MacPort or Fink... ) Output from command

brew reinstall postgresql@14

==> Installing postgresql@14 dependency: icu4c@76
==> ./configure --disable-samples --disable-tests --enable-static --with-library
==> make
Last 15 lines from /Users/sye/Library/Logs/Homebrew/icu4c@76/02.make:
^~~~~~~~~~~~~~
../common/unicode/localpointer.h:551:68: note: expanded from macro 'U_DEFINE_LOCAL_OPEN_POINTER'
    using LocalPointerClassName = internal::LocalOpenPointer
                                                                   ^~~~~~~~~~~~~
2 errors generated.
*** Failed compilation command follows: ----------------------------------------------------------
clang++ -std=gnu++11 -DU_ALL_IMPLEMENTATION -DU_ATTRIBUTE_DEPRECATED= -DU_HAVE_STRTOD_L=1 -DU_HAVE_XLOCALE_H=1 -I../common -O2 -W -Wall -pedantic -Wpointer-arith -Wwrite-strings -Wno-long-long -fno-common -c -dynamic -MMD -MT stubdata.d stubdata.o stubdata.ao -o stubdata.o stubdata.cpp
--- ( rebuild with "/Library/Developer/CommandLineTools/usr/bin/make VERBOSE=1 all" to show all parameters ) --------
make: *** [stubdata.o] Error 1
make: *** Waiting for unfinished jobs....
*** Failed compilation command follows: ----------------------------------------------------------
clang++ -std=gnu++11 -DU_ALL_IMPLEMENTATION -DU_ATTRIBUTE_DEPRECATED= -DU_HAVE_STRTOD_L=1 -DU_HAVE_XLOCALE_H=1 -I../common -O2 -W -Wall -pedantic -Wpointer-arith -Wwrite-strings -Wno-long-long -fno-common -c -MMD -MT stubdata.d stubdata.o stubdata.ao -o stubdata.ao stubdata.cpp
--- ( rebuild with "/Library/Developer/CommandLineTools/usr/bin/make VERBOSE=1 all" to show all parameters ) --------
make: *** [stubdata.ao] Error 1
make: *** [all-recursive] Error 2

I am trying to re-install Postgres via home-brew on Mac. I uninstalled Postgres, updated home-brew and ran the install command for

install postgres

when I run

services start postgresql

I get the below error message: Bootstrap failed: 5: Input/output error Error: Failure while executing; /bin/launchctl bootstrap gui/501 /Users/edac/Library/LaunchAgents/homebrew.mxcl.postgresql.plist exited with 5. When I try to start a server through the Postgres app I receive this message:

Required PostgreSQL version not installed

The data directory was initialized with PostgreSQL 13.

This copy of Postgres.app includes the following PostgreSQL versions: 14.

Please try downloading a different release of Postgres.app.

originally when I installed Postgres all I did was run the home-brew cli and install the app and I was good to go. Not sure what's gone wrong.

I'm trying to install PostgreSQL via [asdf-postgres](https://github.com/smashedtoatoms/asdf-postgres) plugin by running asdf install postgres 12.9 on 2021 MacBook Pro (with M1 Max, running Monterey 12.0.1) but getting the following error:

100   190  100   190    0     0    345      0 --:--:-- --:--:-- --:--:--   346
/Users/kushal/.asdf/plugins/postgres/bin/install: line 45: uconv: command not found
Building with options: --prefix=/Users/kushal/.asdf/installs/postgres/12.9     --with-uuid=e2fs     --with-openssl     --with-zlib     --with-libraries=/opt/local/lib:/sw/lib:/usr/local/opt/openssl/lib:/opt/homebrew/opt/openssl/lib:/usr/local/lib:/usr/lib     --with-includes=/opt/local/lib:/sw/lib:/usr/local/opt/openssl/include:/opt/homebrew/opt/openssl/include:/opt/homebrew/include:/usr/local/include:/usr/local/lib:/usr/lib --with-uuid=e2fs --with-openssl --with-libraries=/usr/local/lib:/opt/homebrew/opt/openssl@1.1/lib --with-includes=/usr/local/include:/opt/homebrew/opt/openssl@1.1/include
checking build system type... Invalid configuration arm64-apple-darwin21.1.0': machine arm64-apple' not recognized
configure: error: /bin/sh config/config.sub arm64-apple-darwin21.1.0 failed

Please note that I'm trying to install it against OpenSSL 1.1 (which is installed via Homebrew already). Also, I'm exported POSTGRES_EXTRA_CONFIGURE_OPTIONS in my zshrc as:

export POSTGRES_EXTRA_CONFIGURE_OPTIONS="--with-uuid=e2fs --with-openssl --with-libraries=/usr/local/lib:/opt/homebrew/opt/openssl@1.1/lib --with-includes=/usr/local/include:/opt/homebrew/opt/openssl@1.1/include"

I believe Postgres is already supported on Apple Silicon, am I missing something here?

% brew search postgresql ==> Formulae postgresql@10 postgresql@11 postgresql@12 postgresql@13 postgresql@14 postgresql@15 postgresql@16 qt-postgresql postgrest % brew install postgresql@16 Warning: You are using macOS 11. We (and Apple) do not provide support for this old version. It is expected behaviour that some formulae will fail to build in this old version. It is expected behaviour that Homebrew will be buggy and slow. Do not create any issues about this on Homebrew's GitHub repositories. Do not create any issues even if you think this message is unrelated. Any opened issues will be immediately closed without response. Do not ask for help from Homebrew or its maintainers on social media. You may ask for help in Homebrew's discussions but are unlikely to receive a response. Try to figure out the problem yourself and submit a fix as a pull request. We will review it but may or may not accept it. Okay, so I'm in murky waters here. But help me understand what the message means. Is it complaining that my chosen version of postgresql (the latest, from all I can see) is too far out of date, or that my Mac OS version is too far out of date? (I'm on MacOS 11.6 Big Sur) The install ends with the following. Likely related, or unrelated? ==> Fetching postgresql@16 ==> Downloading https://ghcr.io/v2/homebrew/core/postgresql/16/blobs/sha256:00985f8cf5b7b9b9adb52fa7d201e188310ce11210d9820efa2295344aed3 ################################################################################################################################## 100.0% ==> Installing dependencies for postgresql@16: gettext and krb5 Error: Cannot link gettext Another version is already linked: /usr/local/Cellar/gettext/0.21

I have downloaded the macOS version of PostgreSQL to my MacBook Air from [postgresql.org](/https://www.postgresql.org/download/) , but I am unable to launch the downloaded program. Below is the error message I am getting:

When I am accessing Fast User Switching, there is a PostgreSQL account: I have uninstalled PostgreSQL account a while back, looked out libraries and no trace of folder PostgreSQL. I am aware that I can hide this account, but it would be ideal to delete it completely.

I have installed postgresql@14 via brew on my Mac M2. Now, when I do brew services I get this output postgresql@14 error 256 headmaster ~/Library/LaunchAgents/homebrew.mxcl.postgresql@14.plist Can anyone help and tell me, how to check where the actual error is? **UPD1** Based on code error 256 found some info with command tail -f /opt/homebrew/var/log/postgresql@14.log 2022-11-26 12:05:14.229 +03 LOG: starting PostgreSQL 14.6 (Homebrew) on aarch64-apple-darwin22.1.0, compiled by Apple clang version 14.0.0 (clang-1400.0.29.202), 64-bit 2022-11-26 12:05:14.231 +03 LOG: could not bind IPv6 address "::1": Address already in use 2022-11-26 12:05:14.231 +03 HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. 2022-11-26 12:05:14.231 +03 LOG: could not bind IPv4 address "127.0.0.1": Address already in use 2022-11-26 12:05:14.231 +03 HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. 2022-11-26 12:05:14.231 +03 WARNING: could not create listen socket for "localhost" 2022-11-26 12:05:14.231 +03 FATAL: could not create any TCP/IP sockets 2022-11-26 12:05:14.232 +03 LOG: database system is shut down **UPD2** based on the error log I checked my etc/hosts ## # Host Database # # localhost is used to configure the loopback interface # when the system is booting. Do not change this entry. ## 127.0.0.1 localhost 255.255.255.255 broadcasthost ::1 localhost # Added by Docker Desktop # To allow the same kube context to work on the host and the container: 127.0.0.1 kubernetes.docker.internal # End of section Not sure, if I should change anything here

Just notice my Mac (running macOS Ventura 13.1) has two copies of **postgres** listed as Login Items in System Settings > General > Login Items. Clicking on the (i) button for EITHER one opens a Finder window highlighting the same file: Macintosh HD/opt/homebrew/Cellar/postgresql@14/14.6/bin/postgres Note: there is a symlink at Macintosh HD/opt/homebrew/Cellar/postgres that points to the 14.6 directory (above). Perhaps one of these Login Items is pointing at the symlink and the other at the executable. But effectively they're both pointing at the same thing. Why is this duplicated? Safe to deselect (or somehow remove) one of them? Update: I have found two **launchd** PostgreSQL plist files in ~/Library/LaunchAgents which I believe to be the culprit:

homebrew.mxcl.postgresql.plist
homebrew.mxcl.postgresql@14.plist

They are basically identical except one points to /opt/homebrew/opt/postgresql/bin/postgres while the other points to /opt/homebrew/opt/postgresql@14/bin/postgres So, I guess my question now is...which one to delete? As mentioned above /opt/homebrew/Cellar/postgresql is a symlink to /opt/homebrew/Cellar/postgresql@14 So...which launchd plist to delete?!?

I have installed [postgress app 2.5.12](https://postgresapp.com/) on my mac and it automatically starts with my system boot. I have checked System Settings > General > Login Items as well as /Library/LaunchDaemons and /Library/LaunchAgents but nothing related to this app is there. How can I disable the automatic launch of this app? I am using MacOS 13.0.1

I forgot how I install postgresql before.
and now I have removed it by following this steps https://stackoverflow.com/a/9240197/12381565 .

But my postgresql user didn't gone from the taskbar, although in my user preference is doesn't have it, so I can't remove it again in the preference.

Maybe I deleted it once, but I forgot about it. thank you.

I migrate a wiki that had a lot of broken link to a domain that no longer exist. How can I massively update my database, instead of change any single link? My idea is to connect in postgres and update manually the database with update table set field = replace(field, 'cat', 'dog') Someone think it's possible? In which table and field I can found my entries?

I decided to let go of postgreSQL today and ran the uninstaller as well as deleted rm /etc/postgres-reg.ini that the uninstaller says you have to remove manually. Now I cannot remember what **the other file to remove manually** was. Furthermore I read online that one should **rm -rf /Library/PostgreSQL** but I seem to not have that folder on my MacBook Pro (Monterey 12.2.1). The third and last problem is that I have a postgres folder in /Users/postgres that **is not found in Users and Groups** (neither on login window) in system settings and **I cannot use rm -rf /Users/postgres either**, so I am lost on how to handle that.

I have installed home-brew v14 psql & psql app v14. It will not allow me to use port 5432 (I spent a week getting this to work and it hasnt), so I have made a server on 4321 which will start. when I type psql in my cli, I get the below error:

psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?

I cannot find the tmp folder to change the port to listen too. Any help will be appreciated. I was able to manually change the port back to 5432 in the postgresapp which worked. now I get this error message when I tap 'psql' in the command line:

psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL:  role "edac" does not exist

I need to restart my Macbook Pro for a new OS update. Somehow the pgAdmin 4 won't quit even I try to quit it from its menu multiple times. Is another way to quit it?

Good morning, I have an old Apple server with macOS 10.12 and Server.app version 5.3 Now I need export the information about devices with DeviceName, SerialNumber and ICCID (for iPad) I found some thread with command for read information with PostgreSQL, but no one with ICCID information. Someone know the correct select command? I found this: 1 - connect to the database sudo psql - U _devicemgr d devicemgr_v2m0 h/Library/Server/ProfileManager/Config/var/PostgreSQL 2 - If you want the names and serial numbers, use Select "DeviceName", "SerialNumber" of devices; I try to use: Select * from devices; And I see the title of the DB columns listed, but none traceable to ICCID... Any help? Thanks

I am trying to connect to PostgreSQL database hosted on Azure programmatically. I am able to do so using apps like [PgAdmin](https://www.pgadmin.org) or [Postico](https://eggerapps.at/postico/) . However, the connection does not work with psql or python. I have the error :

psql: error: could not connect to server: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

I am using a VPN (GlobalProtect v5.1.5-20) on MacOS 10.15.7. If I turn the VPN off and reboot my computer, the exact same psql command does work. Therefore, I don't think it's related to the database server. My main issue is that I don't know where to look at in order to debug. What I've done so far: - Checked the log of Postgres server: can't see my connections attempts. - Checked pg_stat_activity table and can't see any connections from my IP (except the one made with Postico) - Checked with LittleSnitch whether python / psql were able to connect to server. It seems that is the case. - UPDATE: Connecting to Postgres db from a Docker container running locally does work (with or without VPN). Any thoughts ? UPDATE 1, my routing tables * with VPN

Routing tables

Internet:
Destination        Gateway            Flags        Netif Expire
default            10.12.24.32        UGSc         utun2       
default            192.168.0.1        UGScI          en0       
10.12.16.1         10.12.24.32        UGHS         utun2       
10.12.24.32        10.12.24.32        UHr          utun2       
10.12.24.32/32     link#18            UCS          utun2       
66.159.218.152     192.168.0.1        UGHS           en0       
127                127.0.0.1          UCS            lo0       
127.0.0.1          127.0.0.1          UH             lo0       
169.254            link#6             UCS            en0      !
169.254.169.254    link#6             UHLSW          en0      !
192.168.0          link#6             UCS            en0      !
192.168.0.1/32     link#6             UCS            en0      !
192.168.0.1        f4:6b:ef:4c:94:c4  UHLWIir        en0    946
192.168.0.5        f4:6b:ef:4c:94:c5  UHLWIi         en0    450
192.168.0.10       3c:15:c2:c5:50:4c  UHLWI          en0   1197
192.168.0.13       d4:a3:3d:5d:30:f8  UHLWI          en0    577
192.168.0.22/32    link#6             UCS            en0      !
192.168.0.24       46:c5:cd:a2:1e:32  UHLWIi         en0   1182
192.168.0.28       8a:a:f8:f7:a2:d4   UHLWI          en0    191
224.0.0/4          link#18            UmCS         utun2       
224.0.0/4          link#6             UmCSI          en0      !
224.0.0.251        1:0:5e:0:0:fb      UHmLWI         en0       
255.255.255.255/32 link#18            UCS          utun2       
255.255.255.255/32 link#6             UCSI           en0      !

* without VPN

Routing tables

Internet:
Destination        Gateway            Flags        Netif Expire
default            192.168.0.1        UGSc           en0       
127                127.0.0.1          UCS            lo0       
127.0.0.1          127.0.0.1          UH             lo0       
169.254            link#6             UCS            en0      !
169.254.169.254    link#6             UHLSW          en0      !
192.168.0          link#6             UCS            en0      !
192.168.0.1/32     link#6             UCS            en0      !
192.168.0.1        f4:6b:ef:4c:94:c4  UHLWIir        en0    956
192.168.0.5        f4:6b:ef:4c:94:c5  UHLWIi         en0    460
192.168.0.10       3c:15:c2:c5:50:4c  UHLWI          en0    587
192.168.0.13       d4:a3:3d:5d:30:f8  UHLWI          en0    587
192.168.0.22/32    link#6             UCS            en0      !
192.168.0.24       46:c5:cd:a2:1e:32  UHLWIi         en0   1192
192.168.0.28       8a:a:f8:f7:a2:d4   UHLWIi         en0    201
224.0.0/4          link#6             UmCS           en0      !
255.255.255.255/32 link#6             UCS            en0      !

After downloading PgAdmin4 on my MacBook, a new user account "PostgreSQL" was created without my knowledge and with a password that I don't know. Is this normal?

I have Postgresql@11 installed and running. % brew services restart postgresql@11 Stopping postgresql@11... (might take a while) ==> Successfully stopped postgresql@11 (label: homebrew.mxcl.postgresql@11) ==> Successfully started postgresql@11 (label: homebrew.mxcl.postgresql@11) But % psql -d template1 psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? And % which psql /usr/local/opt/postgresql@11/bin/psql What's the matter?

While importing a PostgreSQL database in OS X 10.10, I got a error like "invalid locale name: en_US.utf8". I went to /usr/share/locale and copied the folder en_US.UTF-8 as en_US.utf8. Ok, problem solved. But I know this solution will not work in OS X 10.11 due to that "rootless mode". I'll not be able to modify /usr/share/locale. Is there any way to load this folder from /usr/local/share/locale? I tried to copy en_US.utf8 to that directory and it didn't work.

I have pgAdmin on my dock, and can open it when the process isn't already running (ie. after a restart, or if I manually kill it). If I open pgAdmin, close the window, then later try to open it from the dock, the app doesn't respond. This dock behavior is similar to *MySQL Workbench*, **except** that *MySQL* has the *"running process indicator"* (little circle on dock below the icon), while pgAdmin **does not**, which means that right clicking on the pgAdmin icon does not give me the option to quit. I tried using a bash function, which for MySQL would look like this: killall MySQLWorkbench && open /Applications/MySQLWorkbench.app This works fine for *MySQL Workbench*, but isn't necessary since I can restart it from the dock. For some reason, with pgAdmin, the process doesn't get killed, so the app never opens: >> killall pgAdmin\ 4 No matching processes were found The app is clearly visible in Activity Monitor with the name **pgAdmin 4** The only solution I have currently is to manually kill the process from Activity Monitor, but this is quite redundant. >How can I *conveniently* restart **pgAdmin 4**? I would prefer a solution that allows me to restart it from the dock, but a bash script would also suffice. Software: - *pgAdmin 4* : **4.17** - *macOS Catalina* : **10.15**