it seems it is not a permissions problem, 'cause I can create and delete a table and insert registries to the table as user I have created
postgres@freeswitch-capa8:~/sql$ psql -U freeswitch_user -d freeswitch_db --password
Password for user freeswitch_user:
psql (9.4.15)
Type "help" for help.
freeswitch_db=> CREATE TABLE complete (
freeswitch_db(> sticky INTEGER,
freeswitch_db(> a1 VARCHAR(128),
freeswitch_db(> a2 VARCHAR(128),
freeswitch_db(> a3 VARCHAR(128),
freeswitch_db(> a4 VARCHAR(128),
freeswitch_db(> a5 VARCHAR(128),
freeswitch_db(> a6 VARCHAR(128),
freeswitch_db(> a7 VARCHAR(128),
freeswitch_db(> a8 VARCHAR(128),
freeswitch_db(> a9 VARCHAR(128),
freeswitch_db(> a10 VARCHAR(128),
freeswitch_db(> hostname VARCHAR(256)
freeswitch_db(> );
CREATE TABLE
freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','help','','','','','','','','','freeswitch-capa8');
INSERT 0 1
freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','','','','','','','','','freeswitch-capa8');
INSERT 0 1
freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','help','','','','','','','','freeswitch-capa8');
INSERT 0 1
freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','console','','','','','','','','freeswitch-capa8');
INSERT 0 1
freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','alert','','','','','','','','freeswitch-capa8');
INSERT 0 1
freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','crit','','','','','','','','freeswitch-capa8');
INSERT 0 1
freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','err','','','','','','','','freeswitch-capa8');
INSERT 0 1
freeswitch_db=> \dt
List of relations
Schema | Name | Type | Owner
--------+----------+-------+-----------------
public | complete | table | freeswitch_user
(1 row)
freeswitch_db=> drop table complete;
DROP TABLE
freeswitch_db=> \dt
No relations found.
root@freeswitch-capa8:/usr/local/freeswitch/conf# grep XXX * -R
autoload_configs/switch.conf.xml: <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='U8r9BuntD6iryrKK' options='-c client_min_messages=NOTICE'" />
autoload_configs/directory.conf.xml: <param name="odbc-dsn" value="
pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
autoload_configs/voicemail.conf.xml: <param name="odbc-dsn" value="
pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
autoload_configs/cidlookup.conf.xml: <param name="odbc-dsn" value="
pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
autoload_configs/db.conf.xml: <param name="odbc-dsn" value="
pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
autoload_configs/lcr.conf.xml: <param name="odbc-dsn" value="
pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='
XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
autoload_configs/callcenter.conf.xml: <param name="odbc-dsn" value="
pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='
XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
jingle_profiles/server.xml: <param name="odbc-dsn" value="
pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='
XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
sip_profiles/internal.xml: <param name="odbc-dsn" value="
pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='
XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
sip_profiles/internal-ipv6.xml: <param name="odbc-dsn" value="
pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='
XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
skinny_profiles/internal.xml: <param name="odbc-dsn" value="
pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='
XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />