Home > Cannot Be > Pg_ctl.bin Cannot Be Run As Root

Pg_ctl.bin Cannot Be Run As Root


Do you think that's why it cannot find the configuration file? Let me think about this and see if I have some more ideas for you. Ray_hyperic Jan 21, 2008 11:41 AM (in response to excowboy) Yes, I tried to install as root. I know your experiance level is at or above mine but I ran a message board on pgsql for 3 or 4 years so I have some experience. have a peek at this web-site

My hqdb.log file reads:pg_ctl: PID file "/home/hqexte5/hyperic/server-3.1.4/hqdb/data/postmaster.pid" does not existIs postmaster running?Please advise. roger.symonds Jan 21, 2008 2:30 PM (in response to Ray_hyperic) Sorry just read the original post, please ignore the below post.On a side note have you tried connecting to a remote Possibly getpwuid is looking in /etc/passwd for the uid of a user that does not exist, or could be cause your root. Not the answer you're looking for?

Restart Postgres Server Linux

If you really want to run as root, you need to edit the control scripts.Are you trying to save your data, or just get a working install?If you don't need to So I edited /etc/sysctl.conf appropriately and after restarting the system, I was able to start postgresql successfully via systemctl Offline #6 2012-08-13 09:49:25 g9164313 Member Registered: 2012-08-13 Posts: 1 Re: [SOLVED]Cannot Certainly the author means well, but he fails to see that his own context can't be generalized to other installations.

Version Cluster Port Status Owner Data directory Log file 8.2 main 5432 down root /var/lib/postgresql/8.2/main /var/log/postgresql/postgresql-8.2-main.log I am really stumped at why it won't start, and I am not getting any Safety - Improve braking power in wet conditions Why are wavelengths shorter than visible light neglected by new telescopes? Re: problem with postgresql startup, during installation. Please Log In (using, E.g., "su") As The (unprivileged) User That Will Own The Server Process. River Crossing Puzzle How to stop NPCs from picking up dropped items Story where dome is erected freezing people in time - one person gets trapped outside What is a satisfactory

C++ calculator using classes more hot questions question feed default about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Pg_ctl: Cannot Be Run As Root Mac Short Version ./configure make su make install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 & /usr/local/pgsql/bin/createdb test /usr/local/pgsql/bin/psql test initdb gongomgra 2015-09-18 15:23:59 UTC #6 Hi @rarjunk1999, As mentioned in the error message, you can not run the command as root user. http://dba.stackexchange.com/questions/101103/unable-to-run-postgres-with-pg-ctl ama_hyperic Mar 26, 2008 9:46 AM (in response to fahlenkp) So the external DB was suggested because the installer was having trouble starting the internal DB.

PostgreSql cannot shutdown and neither can that be restarted. Pg_ctl: Server Does Not Shut Down Last edited by deltaecho (2012-06-06 04:09:13) Dylon Offline #5 2012-06-06 04:52:07 TwiNight Member Registered: 2011-06-04 Posts: 46 Re: [SOLVED]Cannot start postgresql using systemctl deltaecho wrote:EDIT: Scratch what I just wrote. hq. mihait_hyperic Mar 26, 2008 8:21 AM (in response to nayyares) Same problem.

Pg_ctl: Cannot Be Run As Root Mac

If I were you, I'd start by executing $export PATH=/usr/lib/postgresql/9.3/bin:$PATH (or even better, put it in your .bashrc). http://serverfault.com/questions/496530/sudo-etc-init-d-postgresql-restart-how-to-chose-which-installation Now for | example, I did some changes to the postgresql.conf file, and when | trying to restart the postgres server, I get this: | | gridmac7:~ schwarzer$ sudo /opt/local/lib/postgresql82/bin/pg_ctl -D Restart Postgres Server Linux Re: problem with postgresql startup, during installation. No Database Directory Specified And Environment Variable Pgdata Unset It appears that postgres offers a lot more choice of options (e.g.

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. I have saved a text file of everything I tried to do in the terminal. With this information it is possible that we can solve it without killing the process. If you follow the steps in the docs you should have a HQ instance up and running without too much trouble. Pg_ctl Command Not Found

Depending on your server installation, it may or may not be installed. Regards,RogerMessage was edited by: roger.symondsMessage was edited by: roger.symonds Like Show 0 Likes (0) Actions 6. asked 1 year ago viewed 2666 times active 1 year ago Related 9PostgreSQL 9.1 Hot Backup Error: the database system is starting up1which postgres do i have installed? You can try this according PostgreSQL version [[email protected] scripts]# /etc/init.d/postgresql-9.1 start Best Regards Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ 15 Jan 2013 01:48:36 Subject: Re:Postgresql could not be started tbidie New

My VMware | VMware.comSearch ActivityBrowseAll ContentBlog PostsDiscussionsDocumentsPollsBookmarksPopular tagsCommunitiesGroupsPeopleLog inRegisterHomeVMTN Forums Mobile AppsBlogsTwitterFacebookGoogle+LinkedInYouTubeGroupsPodcasts vSphere NSXVirtual SAN vCenterFusionWorkstationvExpertVMware {code} CloudCredSubmit a Link Home > VMTN > VMware vCenter™ > vCenter Hyperic Pg_ctl Reload You do you what is the likely reason of unclean shutdown. Example for a commutative subring of a non-commutative ring Why is the 'You talking to me' speech from the movie 'Taxi Driver' so famous?

All rights reserved.

Like Show 0 Likes (0) Actions 3. Within that file is where the postgres options are set.I tried this. It must be having location of pgsql directory where postgresql.conf file will be stored. Initdb Cannot Be Run As Root I tried to do it a different way I found and it gave me this error createuser: creation of new role failed: ERROR: role "Sarah" already exists –tinytown Oct 3 '13

Re: problem with postgresql startup, during installation. How to decline a postdoc interview if there is some possible future collaboration? What's the pun about? RubenITtec Sep 3, 2008 3:45 AM (in response to nayyares) Hi allim trying to install Hyperic on Centos 5 too, unsuccessfully.

Dr Small k_grdnJuly 25th, 2008, 09:52 PMHi, You will find the binaries required to initialize the DB etc.. Now it is working fine… But alfresco is not loading @ startup. In this conf file, there will be port number for that specific pgsql. At the top of that script, you will notice where it imports the postgres config: ". /etc/conf.d/postgresql".

I had a lot of pain… could not log in, during login, got this message: The remote server is unavailable or your credentials were not recognized.I found in logs: 12:05:04,862 ERROR Regards, K_grdn Dr SmallJuly 25th, 2008, 10:50 PMOk, so here's what I have did now, and the outcome of it: sudo mkdir -p /usr/local/pgsql/data sudo chown -R postgres:postgres /usr/local/pgsql/ sudo su More information may be available in the /etc/hyperic/server-3.1.4/logs/hqdb.log file.--------------------------------------------------------------------------------Waiting for server to stop...Stopping built-in database...--------------------------------------------------------------------------------An ERROR occurred, the installation cannot continue.FATAL EXCEPTION at /export/home/hq/hyperic-hq-installer/installer-3.1.4/data/setup.xml:434: : The following error occurred while executing How do I disable auto boot for older server?0PostgreSQL install from source on a systemd distro Hot Network Questions How to prove that authentication system works, and that customer uses the

Would you like to answer one of these unanswered questions instead? Mine was even harder because it was chrooted.