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
>
>
> 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
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
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
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
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
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