The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
16 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
28 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
29 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
82 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
52 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 ...
0
votes
0answers
53 views

Windows Server causes massive lag in Yosemite after 30 minutes

I upgraded to Yosemitte about a month ago or so. It runs super smooth for the first 30 minutes or so and inevitably it starts to bog down severely. I checked activity monitor and Windows Server is ...
2
votes
1answer
1k 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 ...
3
votes
2answers
2k 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
58 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 ...
4
votes
5answers
3k 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 ...
3
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
2k 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 ...
2
votes
2answers
8k 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 ...
2
votes
0answers
850 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 ...
0
votes
0answers
117 views

Installing PostgreSQL on Snow Leopard

I've been trying to install PostgreSQL on my Snow Leopard in order to use django on Heroku. I decided to go with the graphical installer here (http://www.postgresql.org/download/macosx/). However, ...
1
vote
2answers
701 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 ...
0
votes
1answer
418 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
441 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
663 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
4k 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
1k 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
2k 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) ...
0
votes
2answers
4k 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
812 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?