Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [postgresql]

The tag has no usage guidance.

0
votes
1answer
28 views

How to Start Postgres Service in MacOs?

I already install PostgreSQL using homebrew "brew install postgresql". But after that, I will start the service of the Postgres service its give me some error message. pg_ctl -D /usr/local/var/...
0
votes
0answers
56 views

Profile Manager database out of sync

macOS 10.12.6 (Build 16G1510) Server 5.3.1 (Build 16S4128) Users stop getting settings. Example: fresh enrolled computer, successful enrolled, but didn't get any settings from the group or ...
2
votes
3answers
5k views

How to open pgAdmin 4?

I've installed and am trying to open pgAdmin 4 on my Macbook Pro. However, if I right-click it and select "Open", nothing happens. Then again, if I try to re-download pgAdmin 4 and drag that into the ...
0
votes
2answers
139 views

AppleScript export variable to Numbers / Excel / SQL

I would like AppleScript to add a new row on a number or excel sheet (or on a SQL database) I have my data saved on a .plist which I can retrieve with set myDateFromPlist to value of property list ...
1
vote
1answer
1k views

homebrew PostgreSQL upgraded to 10.1 but I need 9.6

I did brew update and brew upgrade Now my PostgreSQL is 10.1 On the server I have 9.6 and I want it to be the same. I can connect and read my data now still (as I assume the brew service didn't ...
2
votes
1answer
583 views

how install postgres 9.6 and a corresponding PostGIS [closed]

How do I install postgres 9.6 and a corresponding PostGIS on macOS Sierra using perhaps homebrew?
10
votes
1answer
17k views

How do you install an older version of Postgres (9.6) using homebrew?

Homebrew's current version of Postgres is 10 when installed with: brew install postgres How do I install an older version of postgres? Specifically 9.6
0
votes
1answer
2k views

How to install pgAdmin 4 in server/Desktop mode on Mac?

How to install pgAdmin 4 on Mac using python wheel. I found a help for Ubuntu https://askubuntu.com/questions/788457/how-to-install-pgadmin-4-in-server-mode-on-ubuntu-16-04 but I did n't find ...
2
votes
1answer
5k views

PostgreSQL not in path after installation

I installed PostgreSQL using the interactive installer by EnterpriseDB following this link. It defaulted the installation directory to /Library/PostgreSQL/9.6. After successful install, psql is not in ...
1
vote
0answers
203 views

postresql not installing with homebrew on El Capitain 10.11.5

brew doctor says 'Your system is ready to brew.' Upon installing with homebrew : brew uninstall postgres && brew install postgres I always get the following error : Data page checksums are ...
3
votes
1answer
99 views

Using postgres with launchd without constant issues

I have postgres and passenger installed from homebrew, and use the os x built in apache. I have several rails apps that use postgres which are managed by passenger which in turn is managed by apache. ...
2
votes
2answers
6k views

Unable to run Postgres after Installation on OSX - El Capitan

I just used homebrew to install my postgres, and I am unable to start it after attempting to start it with the suggested command from postgres/brew. Can someone please advise?
2
votes
1answer
1k views

PostgreSQL- Cannot connect to server

PREFACE: I just bought my first Mac laptop a week ago so that I could get some work done on my trip, but so far I've spent most of my time trying to solve an issue with PostgreSQL. Something went ...
1
vote
1answer
268 views

Load a locale from /usr/local/share/locale in OS X

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 ...
0
votes
1answer
902 views

Running Postgres as Launch Daemon

I am working on setting up a psql server and would therefore like postgres to run whenever the computer is on, regardless of whether I'm logged it. (The machine is running OS X Yosemite.) I set up a ...
30
votes
2answers
53k views

How to restart PostgreSQL installed by Brew in OSX?

In Linux, it can be done by /etc/init.d/postgresql-9.2 restart. My OSX is not a server app. I think it it can be done by ALTER USER postgres with password '1234'; postgreQSL prompt but I am not ...
0
votes
1answer
752 views

How to export Calibre's library for Database Support?

I have used Calibre but I would like get more freedom in exporting it elsewhere for edits. I would like to do quality assurance of my books, papers and literature. Calibre does not communicate with ...
0
votes
1answer
134 views

Creating User to Run Postgres

I'm setting up a postgres server and want to create a separate postgres user to run the process, as recommended in the manual. How do I do this? I installed postgres via Homebrew and have experience ...
1
vote
0answers
104 views

Update massively Wiki server directly in Postgres

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 ...
1
vote
0answers
230 views

Problem reinstalling PostgreSQL after installing Parallels

I’m trying to reinstall postgresql on my mac (yosemite) after installing parallels seemed to mess up permissions to directories that psql and homebrew need. I was able to force-uninstall psql, but ...
0
votes
0answers
100 views

How Do I Override the Addition of the folder for the Server app version of PostgreSQL?

I am currently using RVM for managing different gemsets for different versions of Ruby. RVM has made changes where the RVM folders must be listed first or else I have to manually set the gemset each ...
6
votes
3answers
7k views

/System/Library/LaunchDaemons/com.apple.servermgrd.plist Is Missing - Causing postgres to not start properly

I recently updated my Mac Mini Server to Yosemite and the Server app 4.0. When I tried to verify that Postgres is available by executing sudo serveradmin fullstatus postgres I get the following error:...
3
votes
2answers
3k views

I Cannot Access PostgreSQL At Times After Server App Upgrade

I am running the latest version of Mavericks 10.9.5 on my Mac Mini Server. Before the upgrade to the latest version of the Server App 3.2.1 I was able to access PostgreSQL in my Ruby on Rails ...
1
vote
1answer
549 views

How do I determine where a process is being started from, and disable it?

When I start OS X (Mavericks) and run ps aux | grep postgres from Terminal, I have a process that was automatically started: postgres 132 0.0 0.1 2526456 7936 ?? Ss 10:04PM 0:00....
4
votes
5answers
5k views

/Library/Server/Wiki/Database.xpg consuming huge amount (313GB!) of disk space

Over the last few days I've noticed the amount of free space on my HD has been plummeting. After a bit of investigation, I found it was due to the folder /Library/Server/Wiki/Database.xpg. It was ...
2
votes
1answer
2k views

Using Mac OS X 10.9 lsof launches 5 to 10 processes at a time on its own taking all cpu

I am running a MacBook Air 13 (Latest) with 8GB / 512 Flash / Core Intel i7. Lately shortly after bootup I hear the fans winding at top speed. I checked the top processes and see several instances ...
4
votes
2answers
2k views

PostgreSQL causing slow shutdowns with OS X Server in Mavericks

I've found that on OS X Server in Mavericks, the PostgreSQL processes are causing shutdown delays. During a verbose shutdown, I get the following (shortened) output: com.apple.launchd ...
5
votes
1answer
3k views

Is there a reason why OS X Mavericks Server is running Postgresql?

I recently installed OS X Mavericks Server on my computer to use for Xcode continuous integration. I now see that the postgresql database is running via the Activity Monitor, and some investigation ...
7
votes
2answers
30k views

What is postgres and why is it running on my system?

Upon every login to my computer, I notice in Activity Monitor I have several instances of a process called "postgres" running, under the user "postgres". What is this, and why does it launch every ...
3
votes
0answers
1k views

shmmax and shmall values in /etc/sysctl.conf are not loaded on reboot

I'm running OSX 10.8.4 and I would like to add a factor of 10 to the default shmmax and shmall values. My /etc/sysctl.conf contains the following settings: kern.sysv.shmmax=41943040 kern.sysv.shmmin=...
1
vote
2answers
2k views

Password problems changing users in Terminal

I'd like to switch between the default user in Terminal and the user 'postgres', created when I installed PostgreSQL 9.2. If I type su postgres, I'm prompted for a password that I don't know and don'...
1
vote
1answer
1k views

Homebrew installed PostgreSQL for use by multiple accounts

I'm using Homebrew to install PostgreSQL (PG) on a MacBook Air. admin user brew installed PostgreSQL. I'd like another (mobile account) user to be able to use the database for Rails development. ...
-1
votes
1answer
456 views

PostgreSQL on Mountain Lion Server Autostart

PostgreSQL now comes with Server on 10.8+. However, postgres seems to require restarting often. How can I keep postgres running without having to restart it so often?
0
votes
1answer
2k views

How to enable TCP/IP for Postgres on OS X 10.7 Server?

The default configuration in /var/pgsql/postgresql.conf says that listen_addresses defaults to localhost, but it doesn't let me connect over port 5432. Connecting (as root, using sudo) over a Unix ...
1
vote
2answers
5k views

Update to latest libssl for Mountain Lion without MacPorts?

I've tried installing postgresql, used the install pkg from EnterpriseDB 9.1.5, now psql isn't working. Seems to be a path issue, but now, there's the matter of libssl. Seems there is a new version, ...
0
votes
1answer
3k views

How can I start postgres automatically on startup?

I can start postgres with: # Start Postgres /usr/local/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start Where can I put that to start up when I start the machine up? I can put it in my ....
1
vote
2answers
3k views

Device manager and Postgresql error message loop

I'm on MBP 7,1, 2.4GHz Intel Core 2 Duo, 4GB DDR3 Ram, 500GB hard drive with Lion. After the v10.7.3 update, the console has been putting a looping error message regarding Device manager and PostGre ...
0
votes
2answers
2k views

How to configure postgresql in Lion

I am new in mac os. I was trying to install Postgresql. Before i did not know there is a Postgresql already available with default installation. So, I downloaded Postgresql 8.4 and installed it. I ...
2
votes
2answers
1k views

Is the performance of Lion + SSD + Filevault2 good enough for a system primarily used for application developemnt?

I'm looking to buy a MacBook Pro w/ SSD. I was wondering if anyone out there has noticed any significant performance drop with FileVault2 enabled for the following tasks: Small (under 2 GB) ...
1
vote
2answers
12k views

How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on Mac OS X 10.7?

I'm running Mac OS X 10.7. How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on the system?
-1
votes
2answers
865 views

Setup macbook pro for ruby on rails development

I just got my first Macbook :). And now I want to configure it for Ruby on rails development. I want to setup following things: Textmate Ruby using RVM Rails Mysql Postgresql Apache Also I am ...
0
votes
2answers
2k views

I need help uninstalling PostgreSQL on my Mac running 10.7

I got PostgreSQL from here. Since I'm on 10.7 OS X, I'm having problems. I want to uninstall the software I got from enterprisedb. Any tips?