Installation issues

[NikolayS]

nikolay@dev:~/github$ cd pgcenter/
nikolay@dev:~/github/pgcenter$ make
gcc -g -std=gnu99 -Wall -pedantic -I/usr/include/postgresql -L/usr/lib/x86_64-linux-gnu -o pgcenter pgcenter.c -lncurses -ltinfo -lpq
pgcenter.c:11:21: fatal error: ncurses.h: No such file or directory
 #include <ncurses.h>
                     ^
compilation terminated.
Makefile:25: recipe for target 'pgcenter' failed
make: *** [pgcenter] Error 1
nikolay@dev:~/github/pgcenter$ uname -a
Linux dev 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt11-1+deb8u2 (2015-07-17) x86_64 GNU/Linux

[lesovsky]

Check that the ncurses devel package installed.
If installed:

1. what OS you use?
2. exec "find / -type f -name curses.h -name ncurses.h 2>/dev/null" and show results.

[NikolayS]

It's Debian.
sudo apt-get install ncurses-dev solved the issue.

Another one:

I run at under postgres user, wherepsql works w/o password (double-checked it).
I checked your readme, and cannot find any directions how to set up usr/pwd params for pgcenter.

[NikolayS]

OK, I guessed that it has the same options as psql does :)
Maybe it's worth mentioning in readme.
I'm closing the issue.

[NikolayS]

(and maybe it's a good idea to allow working w/o password -- in case when psql works without it)

[NikolayS]

Reopening.. It cannot connect even when I run it like this:

pgcenter -U username dbname -W

• strange that without -W it doesn't ask for password
• even with password, it still cannot connect.

Postgres version is 9.4.3.

[lesovsky]

See path specified in unix_socket_directories in postgresql.conf, and try "-h path"

[NikolayS]

Ahrrr, adding -h localhost solved the issue.

[lesovsky]

The problem is that the postgres pkg developers use different default host in psql. RHEL uses /tmp, Debian uses /var/run/postgresql. pgCenter uses RHEL way. And Debian/Ubuntu users may have problem here.

I think how to solve this issue with elegant way.

[lesovsky]

try a935265

[NikolayS]

Works w/o pwd now, thanks