Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

2016-08-02 Thread Patrick B
This is now solved guys. There were three problems. 1 - I was looking for the logs on /var/lib/postgresql/9.2/main/pg_log. And it's wrong. On ubuntu, the logs are: /var/log/postgresql 2 - I just changed the max_stack_depth to the default DETAIL: "max_stack_depth" must not exceed 7680kB. > HINT

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

2016-08-02 Thread Patrick B
> > > Short version: > > That probably should be postgresql not postgres > > Long version: > > https://help.ubuntu.com/community/PostgreSQL > > >> > Yep.. my mistake.. /etc/init.d/postgresql start/stop/restart

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

2016-08-02 Thread John R Pierce
On 8/2/2016 1:17 PM, Patrick B wrote: Ubuntu 16.04.1 LTS How did you install Postgres and from where? apt-get install postgresql-9.2 postgresql-contrib-9.2 dpkg -l postgresql When I start it, it doesn't start... Show the command you used to start it. /etc/init.d/postg

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

2016-08-02 Thread Adrian Klaver
On 08/02/2016 01:17 PM, Patrick B wrote: 2016-08-03 8:13 GMT+12:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 08/02/2016 01:04 PM, Patrick B wrote: Hi guys, I've installed potgres on a Ubuntu machine. Postgres version? have a look on the subjec of this e

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

2016-08-02 Thread Patrick B
So, I found a log file on /var/log/postgres/ DETAIL: "max_stack_depth" must not exceed 7680kB. > HINT: Increase the platform's stack depth limit via "ulimit -s" or local > equivalent. > 2016-08-02 19:54:06.293 UTC|12960|FATAL: configuration file > "/etc/postgresql/9.2/main/postgresql.conf" cont

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

2016-08-02 Thread Patrick B
2016-08-03 8:13 GMT+12:00 Adrian Klaver : > On 08/02/2016 01:04 PM, Patrick B wrote: > >> Hi guys, >> >> I've installed potgres on a Ubuntu machine. >> > > Postgres version? > have a look on the subjec of this email (9.2) > > Ubuntu version? > Ubuntu 16.04.1 LTS > > How did you install Postg

Re: [GENERAL] Postgresql 9.2 Ubuntu - is not starting

2016-08-02 Thread Adrian Klaver
On 08/02/2016 01:04 PM, Patrick B wrote: Hi guys, I've installed potgres on a Ubuntu machine. Postgres version? Ubuntu version? How did you install Postgres and from where? When I start it, it doesn't start... Show the command you used to start it. /etc/init.d/postgresql status