[GENERAL] Too many postgres instances
Hi, Can anyone explain to me why my system is spawn so many postgress instances? System: FreeBSD 7.2 Stable I386 RAM: < 1GB Here is the output of the top command: Mem: 457M Active, 92M Inact, 150M Wired, 23M Cache, 85M Buf, 18M Free Swap: 999M Total, 150M Used, 849M Free, 14% Inuse Here is a list of the postgres instances running in my system: pgsql 70502 0.0 0.5 10364 3800 ?? Ss2:24AM 0:28.85 postgres: stats collector process(postgres) pgsql 70797 0.0 0.4 49724 2892 ?? Is2:28AM 0:00.24 postgres: liferay lportal 127.0.0.1(54110) (postgres) pgsql 70798 0.0 0.7 49724 5060 ?? Is2:28AM 0:00.43 postgres: liferay lportal 127.0.0.1(52754) (postgres) pgsql 70799 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(49593) (postgres) pgsql 70800 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(55760) (postgres) pgsql 70801 0.0 0.6 49724 5016 ?? Is2:28AM 0:00.56 postgres: liferay lportal 127.0.0.1(56710) (postgres) pgsql 70802 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(65367) (postgres) pgsql 70803 0.0 0.6 49724 4508 ?? Is2:28AM 0:00.27 postgres: liferay lportal 127.0.0.1(55101) (postgres) pgsql 70804 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(62522) (postgres) pgsql 70805 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(57897) (postgres) pgsql 70806 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(51393) (postgres) pgsql 70894 0.0 0.8 49724 5908 ?? Is2:30AM 0:00.67 postgres: liferay lportal 127.0.0.1(65399) (postgres) pgsql 70895 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(54991) (postgres) pgsql 70896 0.0 0.7 49724 5412 ?? Is2:30AM 0:00.65 postgres: liferay lportal 127.0.0.1(63123) (postgres) pgsql 70897 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(63978) (postgres) pgsql 70898 0.0 0.8 49724 6284 ?? Is2:30AM 0:00.59 postgres: liferay lportal 127.0.0.1(65359) (postgres) pgsql 70902 0.0 0.6 49724 4264 ?? Is2:30AM 0:00.25 postgres: liferay lportal 127.0.0.1(50233) (postgres) pgsql 70903 0.0 0.6 49724 4924 ?? Is2:30AM 0:00.41 postgres: liferay lportal 127.0.0.1(65401) (postgres) pgsql 70904 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(63124) (postgres) pgsql 70905 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(54153) (postgres) pgsql 70906 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(63712) (postgres) pgsql 80297 0.0 0.7 49724 5044 ?? Is6:22AM 0:00.28 postgres: liferay lportal 127.0.0.1(58431) (postgres) pgsql 80298 0.0 0.7 48700 5288 ?? Is6:22AM 0:00.48 postgres: liferay lportal 127.0.0.1(50051) (postgres) pgsql 80299 0.0 1.0 49724 7600 ?? Is6:22AM 0:00.30 postgres: liferay lportal 127.0.0.1(49678) (postgres) pgsql 80300 0.0 0.7 48700 5380 ?? Is6:22AM 0:00.67 postgres: liferay lportal 127.0.0.1(58183) (postgres) pgsql 80301 0.0 0.6 49724 4748 ?? Is6:22AM 0:00.37 postgres: liferay lportal 127.0.0.1(55792) (postgres) pgsql 93527 0.0 0.4 49724 3464 ?? Is 11:28AM 0:00.14 postgres: liferay lportal 127.0.0.1(54222) (postgres) pgsql 93528 0.0 0.0 48700 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(52385) (postgres) pgsql 93529 0.0 0.0 48700 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(59677) (postgres) pgsql 93530 0.0 0.0 48700 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(60016) (postgres) pgsql 93531 0.0 0.0 49724 0 ?? IWs - 0:00.00 postgres: liferay lportal 127.0.0.1(56885) (postgres) pgsql 95330 0.0 0.9 49724 6812 ?? Is 12:05PM 0:00.18 postgres: liferay lportal 127.0.0.1(55050) (postgres) pgsql 95331 0.0 0.7 48700 5680 ?? Is 12:05PM 0:00.07 postgres: liferay lportal 127.0.0.1(53490) (postgres) pgsql 95332 0.0 0.8 49724 6572 ?? Is 12:05PM 0:00.47 postgres: liferay lportal 127.0.0.1(50029) (postgres) pgsql 95333 0.0 0.5 48700 3544 ?? Is 12:05PM 0:00.04 postgres: liferay lportal 127.0.0.1(65012) (postgres) pgsql 95334 0.0 0.8 48700 6236 ?? Is 12:05PM 0:00.06 postgres: liferay lportal 127.0.0.1(57130) (postgres) It seems I don't have enough memory to run my Liferay web portal, there are 3 web portal instances are running, but some of the primary keys are failed to index properly: .. 16:40:18,175 WARN [ResourceActionsUtil:564] Unable to obtain resource actions for unknown portlet SampleContactUs 17:45:17,326 WARN [PortalImpl:2948] Current URL /c/portal/login?p_l_id=10404 gene
Re: [GENERAL] Can't start postgresql 8.3.7
I copied the sample config file to postgresql workign directory before trying to start postgresql: # pwd /usr/local/share/postgresql twp1:postgresql # cp postgresql.conf.sample ../../pgsql/data/postgresql.conf On Fri, Jun 26, 2009 at 4:04 PM, Sam Wun wrote: > Hi, > > I had been running postgresql 8.3.7 in freebsd for some time, but > after I changed its postgresql.conf file, it can't start any more > eventhoguh I changed the config back to its original file. > Anything wrong? > > Here is the errros: > > Jun 26 15:58:52 twp1 postgres[1394]: [1-1] FATAL: could not create > semaphores: No space left on device > Jun 26 15:58:52 twp1 postgres[1394]: [1-2] DETAIL: Failed system call > was semget(5432004, 17, 03600). > Jun 26 15:58:52 twp1 postgres[1394]: [1-3] HINT: This error does > *not* mean that you have run out of disk space. > Jun 26 15:58:52 twp1 postgres[1394]: [1-4] It occurs when either > the system limit for the maximum number of semaphore sets (SEMMNI), or > the system wide maximum number of > Jun 26 15:58:52 twp1 postgres[1394]: [1-5] semaphores (SEMMNS), would > be exceeded. You need to raise the respective kernel parameter. > Alternatively, reduce PostgreSQL's > Jun 26 15:58:52 twp1 postgres[1394]: [1-6] consumption of semaphores > by reducing its max_connections parameter (currently 103). > Jun 26 15:58:52 twp1 postgres[1394]: [1-7] The PostgreSQL > documentation contains more information about configuring your system > for PostgreSQL. > > Very appreciate for any suggestion. > Thanks > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Can't start postgresql 8.3.7
Hi, I had been running postgresql 8.3.7 in freebsd for some time, but after I changed its postgresql.conf file, it can't start any more eventhoguh I changed the config back to its original file. Anything wrong? Here is the errros: Jun 26 15:58:52 twp1 postgres[1394]: [1-1] FATAL: could not create semaphores: No space left on device Jun 26 15:58:52 twp1 postgres[1394]: [1-2] DETAIL: Failed system call was semget(5432004, 17, 03600). Jun 26 15:58:52 twp1 postgres[1394]: [1-3] HINT: This error does *not* mean that you have run out of disk space. Jun 26 15:58:52 twp1 postgres[1394]: [1-4] It occurs when either the system limit for the maximum number of semaphore sets (SEMMNI), or the system wide maximum number of Jun 26 15:58:52 twp1 postgres[1394]: [1-5] semaphores (SEMMNS), would be exceeded. You need to raise the respective kernel parameter. Alternatively, reduce PostgreSQL's Jun 26 15:58:52 twp1 postgres[1394]: [1-6] consumption of semaphores by reducing its max_connections parameter (currently 103). Jun 26 15:58:52 twp1 postgres[1394]: [1-7] The PostgreSQL documentation contains more information about configuring your system for PostgreSQL. Very appreciate for any suggestion. Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] how to create an admin user for restore database.
Hi, With PG 8.4, I can't find a documentation to show me how to create a super user or admin user for the PGSQL. I have crated a user called "liferayadmin" and a database "liferay". then executed the following command: GRANT ALL PRIVILEGES ON DATABASE liferay to liferayadmin; When I launched pgadmin in windows and login as user liferayadmin, from the tools menu, the restore command is disabled. I think the user "liferayadmin" does not have the privilege to restore database. How can I enable a user with restore permission? Your help is very much appreciated Thanks Sam -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] how to create an admin user for restore database.
With user liferayadmin on db liferay, I got the following errors: 03:14:50,558 WARN [DBUtil:474] ERROR: permission denied for relation quartz_locks: insert into QUARTZ_LOCKS values('TRIGGER_ACCESS'); 03:14:50,567 WARN [DBUtil:474] ERROR: permission denied for relation quartz_locks: insert into QUARTZ_LOCKS values('JOB_ACCESS'); 03:14:50,582 WARN [DBUtil:474] ERROR: permission denied for relation quartz_locks: insert into QUARTZ_LOCKS values('CALENDAR_ACCESS'); 03:14:50,593 WARN [DBUtil:474] ERROR: permission denied for relation quartz_locks: insert into QUARTZ_LOCKS values('STATE_ACCESS'); 03:14:50,608 WARN [DBUtil:474] ERROR: permission denied for relation quartz_locks: insert into QUARTZ_LOCKS values('MISFIRE_ACCESS'); ... How can I assigne admin permission to liferayadmin user? Thanks sam On Wed, Jun 23, 2010 at 12:24 PM, Adrian Klaver wrote: > On Tuesday 22 June 2010 6:50:28 pm Sam Wun wrote: >> Hi, >> >> With PG 8.4, I can't find a documentation to show me how to create a >> super user or admin user for the PGSQL. >> >> I have crated a user called "liferayadmin" and a database "liferay". >> >> then executed the following command: >> >> GRANT ALL PRIVILEGES ON DATABASE liferay to liferayadmin; >> >> When I launched pgadmin in windows and login as user liferayadmin, >> from the tools menu, the restore command is disabled. >> I think the user "liferayadmin" does not have the privilege to restore >> database. >> >> How can I enable a user with restore permission? >> >> Your help is very much appreciated >> >> Thanks >> Sam > > You do say how you installed Postgres. Generally by the default there is a > super > user created with name of postgres. Also generally by default there is a local > connection set up with an authentication of trust. You should be able to log > in > as postgres and have the necessary permissions. > > -- > Adrian Klaver > adrian.kla...@gmail.com > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general