Postgresql Not Starting
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-26-2015 01:57 PM
Hello,
I have alfresco 4.0.c setup in my office. Suddenly alfresco stop working. Postgresql not starting. Tomcat is starting. When i open the link it throws me error 404. and /share link is opening.
"/opt/alfresco-4.0.c/postgresql/scripts/ctl.sh : postgresql could not be started"
Please help me. I got stuck.
I have alfresco 4.0.c setup in my office. Suddenly alfresco stop working. Postgresql not starting. Tomcat is starting. When i open the link it throws me error 404. and /share link is opening.
"/opt/alfresco-4.0.c/postgresql/scripts/ctl.sh : postgresql could not be started"
Please help me. I got stuck.
Labels:
- Labels:
-
Archive
6 REPLIES 6
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-26-2015 03:41 PM
You need to find your postgresql error log probably in /var/alfresco/postgresql/postgresql.log this will tell you the error. Look at the bottom of the file as this log does not get truncated or rolled over.
Very often it is that permissions are wrong.
Very often it is that permissions are wrong.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-26-2015 03:50 PM
thnx but my postgres.log file is empty and i am using alfresco comunity edition without modified.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-26-2015 06:34 PM
First look in /opt/alfresco-4.0.c/postgresql/scripts/ctl.sh, find the definition of POSTGRESQL_START and try running that from the command line. You may get a better error. If not, check /opt/alfresco-4.0.c/postgresql/bin/ctl.sh and check where it is writing your error files in case its somewhere else.
fialing that add -d 3 to the POSTGRESQL_START command which should give more extensive debuging.
This is usually a permissions error on the data directory.
fialing that add -d 3 to the POSTGRESQL_START command which should give more extensive debuging.
This is usually a permissions error on the data directory.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-27-2015 09:49 AM
[root@t2 scripts]# /opt/alfresco-4.0.c/postgresql/bin/postgres -d 3 /opt/alfresco-4.0.c/alf_data/postgresql -p 5432
/opt/alfresco-4.0.c/postgresql/bin/postgres: error while loading shared libraries: libssl.so.0.9.8: cannot open shared object file: No such file or directory
error found.
[postgres@tn2 bin]$ ./pg_ctl restart
pg_ctl.bin: PID file "/opt/alfresco-4.0.c/alf_data/postgresql/postmaster.pid" does not exist
Is server running?
starting server anyway
server starting
when i try to run pg_ctl i get the above error.
Please help me !!!
/opt/alfresco-4.0.c/postgresql/bin/postgres: error while loading shared libraries: libssl.so.0.9.8: cannot open shared object file: No such file or directory
error found.
[postgres@tn2 bin]$ ./pg_ctl restart
pg_ctl.bin: PID file "/opt/alfresco-4.0.c/alf_data/postgresql/postmaster.pid" does not exist
Is server running?
starting server anyway
server starting
when i try to run pg_ctl i get the above error.
Please help me !!!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-27-2015 10:32 AM
What you look to have proved here is that the PATH environment for user root does not have the folder that libssl.so.0.9.8 lives in and the user postgres does.
What user does Alfresco start under? Do you log in & start Alfresco manually or does it start when you boot the machine? If it starts on boot, check the init.d/alfresco file & see what user it starts under.
What you need to make sure is as follows:-
The user that starts alfresco has permissions to read and write alf_data and all files & folders including postgres ones. Do NOT make everything globally writeable, if you do Postgres won't start for other reasons but make sure that user that starts alfresco has read / write (and as appropriate execute) on all of alf_data. Make sure that user has in its path the folder the contains the library.
I suspect that Alfresco does not run as root (it shouldn't) and that the user it does run under now does not have enough permissions to start postgres.
What user does Alfresco start under? Do you log in & start Alfresco manually or does it start when you boot the machine? If it starts on boot, check the init.d/alfresco file & see what user it starts under.
What you need to make sure is as follows:-
The user that starts alfresco has permissions to read and write alf_data and all files & folders including postgres ones. Do NOT make everything globally writeable, if you do Postgres won't start for other reasons but make sure that user that starts alfresco has read / write (and as appropriate execute) on all of alf_data. Make sure that user has in its path the folder the contains the library.
I suspect that Alfresco does not run as root (it shouldn't) and that the user it does run under now does not have enough permissions to start postgres.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-27-2015 01:47 PM
I am starting alfresco from root user. and from past 1 year its working fine and suddenly its stop working.
Please help me.
Please help me.
