Home > Cannot Be > Pg_ctl Cannot Be Run As Root

Pg_ctl Cannot Be Run As Root

Contents

delirium:~ anna$ sudo su postgres delirium:~ anna$ Nothing happens. The DBA requirement in the docs is there simply because it would be generally sub optimal for someone with zero experience with oracle/postgres/mysql to go and install and configure it. Do you know why ? Re: problem with postgresql startup, during installation. Check This Out

It did not work. It may be easier to just create the default PGDATA directory and then initdb /var/lib/postgresql/8.2/main. Thanks. can you please check postgres logs on below location and see if there is any clue? /var/lib/pgsql/data/pg_log Sunile Manjee Jitendra Yadav ♦ · Jul 05 at 04:08 AM 0 Share @Jitendra

Restart Postgres Server Linux

No, setup does not allow you to run as root and boots you out of an install if you try. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Comment Add comment · Show 1 10 |6000 characters needed characters left characters exceeded ▼ Viewable by all users Viewable by moderators Viewable by moderators and the original poster Advanced visibility

What happens when a wizard tries to cast a cone of cold through a wall of fire? hq. But over xinetd or after switching user it wont work0How to run an Ansible command with the user id root0Login as postgres user in mac Hot Network Questions What is the Pg_ctl: Command Not Found This would mean you wouldn't have to rewrite the init.d script too.

How did you install postgres? Pg_ctl: Cannot Be Run As Root Mac Still I am getting error as follows:[[email protected] sudeep]# systemctl start postgresql.service [[email protected] sudeep]# systemctl status postgresql.service postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled) Active: failed (Result: exit-code) since Wed, RubenITtec Oct 7, 2008 8:24 AM (in response to RubenITtec) Nobody? :( Like Show 0 Likes (0) Actions 12. share|improve this answer edited May 10 '15 at 17:45 answered May 10 '15 at 17:40 Vérace 10.6k11532 I installed postgresql from apt-get.

Last update was at 14 Jan 2013 08:50:56 14 Jan 2013 09:09:26 Subject: Re:Postgresql could not be started raghavendra_rao Senior member Joined: 2 Sep 2009 06:28:39 Messages: 236 Offline You Initdb: Cannot Be Run As Root You can install from source without purging - just make sure that your apt-get server isn't working - or at least that the port is different. Safety - Improve braking power in wet conditions Mimsy were the Borogoves - why is "mimsy" an adjective? There are a few of these - Google these - but they're not necessary if you specify paths yourself.

Pg_ctl: Cannot Be Run As Root Mac

You would have this file: /Library/Server/PostgreSQL/Config/org.postgresql.postgres.plist You can sudo: sudo -u _postgres psql template1 Or connect: psql -h localhost -U _postgres postgres share|improve this answer answered May 17 '13 at 22:37 http://forums.enterprisedb.com/posts/list/3508.page Do you think that's why it cannot find the configuration file? Restart Postgres Server Linux AngellFire Oct 17, 2009 8:16 AM (in response to RubenITtec) SOLVED...!! No Database Directory Specified And Environment Variable Pgdata Unset What is the point of update independent rendering in a game loop?

Not the answer you're looking for? Oracle SQL - can I return the "before" state of a column value 301RedirectModule isn't working for URL with dot file name Show that the square matrix A is invertible On Anyhow, here is the file: #!/bin/sh -e ################################# ## Script rewriten by Dr Small ## ################################# PGVER='8.2' BINPATH="/usr/lib/postgresql/$PGVER/bin/" PGUSER='postgres' PGLOG='/tmp/pgsql.log' PGDIR='/usr/local/pgsql/data' start() { cd $BINPATH su $PGUSER -c "./pg_ctl -D $PGDIR It is incredible kind of you you help me so much! Please Log In (using, E.g., "su") As The (unprivileged) User That Will Own The Server Process.

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? Within that file is where the postgres options are set. I'm fairly sure that the postgres user exists. I can not start my alfresco install anymore.

Do humans have an ethical obligation to prevent animal on animal violence? Pg_ctl: Server Does Not Shut Down What do I do? Community Connection Answers Knowledge Base Code Hub Search 11126 Questions | 178 Repos | 1527 Articles Create Ask a question Post Idea Add Repo Create Article Tracks Community Help Cloud &

So your last command in the question should be amended as: /usr/lib/postgresql/9.3/bin/pg_ctl start \ "-D" "/var/lib/postgresql/9.3/main" \ "-o -c config_file=/etc/postgresql/9.3/main/postgresql.conf" share|improve this answer answered May 10 '15 at 21:21 Daniel Vérité

What does "there lived here then" mean? Verify that the directory points to the correct location.2. Try creating the postgres user, also check pg_hba.conf to make sure your accepting connections from the local host, also clarify which interfaces postgresql is listening on after successful startup. Pg_ctl Reload more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

I've just installed hyperic-hq-installer-3.1.4-504-sparc-solaris.tgz on Solaris 10 without any problems. See system journal and 'systemctl status' for details. [[email protected] sudeep]# systemctl status postgresql.service postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled) Active: failed (Result: exit-code) since Mon, 04 Jun 2012 Does Intel sell CPUs in ribbons? UPDATE: following the answer I received from Micah Yoder I did a: /usr/lib/postgresql/9.2/bin/pg_ctl -D /var/lib/postgresql/9.2/main restart which was met with "could not open PID file /var/lib/postgresql/9.2/main/main/postmaster.pid permission denied".

I'm not that smart. I deleted the database, and created a new one. netstat does not show postgresql running either. Now on trying to log in as postgres and fire it up I get this:[/usr/local/src/hyperic-hq-installer] > psqlpsql: FATAL: database "postgres" does not exist[/usr/local/src/hyperic-hq-installer] > locate psql[/usr/local/src/hyperic-hq-installer] >Any ideas to people who

What am I doing wrong here? Please tell me the default postgres user password. As a monk, can I use Deflect Missiles to protect my ally? What now?

Run it as the 'postgres' user. Ray_hyperic Jan 21, 2008 11:41 AM (in response to excowboy) Yes, I tried to install as root. Let me think about this and see if I have some more ideas for you. postgresql share|improve this question edited Apr 5 '13 at 16:41 asked Apr 5 '13 at 15:52 Menelaos Perdikeas 138116 add a comment| 3 Answers 3 active oldest votes up vote 3

I posted a solution to this issue in the following thread: http://ubuntuforums.org/showthread.php?p=8389411&posted=1#post8389411 Powered by vBulletin Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. Try sudo -u postgres bash share|improve this answer answered May 25 '12 at 11:14 Iain 3,5021519 add a comment| up vote 0 down vote PostgreSQL is integrated in Server.app available through Last update was at 16 Jan 2013 07:47:46 Forum Index » PostgreSQL (formerly Standard Server) Go to: Select a forum News & Announcements Website Issues EDB Postgres Advanced Server EDB If manually have you created the initial database?

Running: sudo su - postgres Logs me in as the postgres user. I am working with the administrators of the box to narrow down what would be causing this. Looking in the corresponding file, I noticed that it made several references to $PGROOT, and since the statement "Creating symlink /var/lib/postgres -> $PGROOT" returned the empty string for $PGROOT, I figured