Re: [GENERAL] how to create an admin user for restore database.

2010-06-22 Thread Sam Wun
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&

[GENERAL] how to create an admin user for restore database.

2010-06-22 Thread Sam Wun
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 p

[GENERAL] Can't start postgresql 8.3.7

2009-06-25 Thread Sam Wun
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 crea

Re: [GENERAL] Can't start postgresql 8.3.7

2009-06-25 Thread Sam Wun
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 p

[GENERAL] Too many postgres instances

2009-06-18 Thread Sam Wun
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 lis