Do you see any active connections? A query like this in pgsql might give you some information:
SELECT datname,procpid,current_query FROM pg_stat_activity; On Thu, Aug 22, 2013 at 9:54 AM, Miguel Angel Coa Morales <[email protected]> wrote: > My setting for db I've the next: > > [……………..] > [root@master puppet]# cat /etc/puppetdb/conf.d/config.ini | grep -v ^# > > [global] > vardir = /var/lib/puppetdb > logging-config = /etc/puppetdb/log4j.properties > > resource-query-limit = 20000 > [command-processing] > > [database] > classname = org.postgresql.Driver > subprotocol = postgresql > subname = //localhost:5432/puppetdb > username = puppetdb > password = puppetdb > > [jetty] > port = 8080 > [……………..] > > My routes.yaml > > [……………..] > /etc/puppet/routes.yaml > > master: > facts: > terminus: puppetdb > cache: yaml > [……………..] > > My /etc/puppet/puppetdb.conf > > [……………..] > [main] > > server = master.example.com > port = 8081 > [……………..] > > Thanks. > > El 22-08-2013, a las 12:47, Ken Barber <[email protected]> escribió: > >> Check your /etc/puppetdb/database.ini, it may be configured for >> hsqldb. If in doubt provide the file here and we can take a look. >> >> Instructions for configuring this specifically for PostgreSQL are >> here: http://docs.puppetlabs.com/puppetdb/1.4/configure.html#using-postgresql >> >> On Thu, Aug 22, 2013 at 7:34 AM, Miguel Angel Coa Morales >> <[email protected]> wrote: >>> Yes I can connect but when i list tables i have the next message "No >>> relations found." >>> >>> 1. Connect from my node: [root@node1 ~]# psql -h 10.0.0.132 puppetdb >>> puppetdb >>> 2. Show tables: puppetdb=> \d >>> No relations found. >>> 3. My databases are: >>> >>> puppetdb=> \l puppetdb >>> List of databases >>> Name | Owner | Encoding | Collation | Ctype | Access >>> privileges >>> -----------+----------+----------+-------------+-------------+----------------------- >>> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | >>> puppetdb | puppetdb | UTF8 | en_US.UTF-8 | en_US.UTF-8 | >>> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres >>> : >>> postgres=CTc/postgres >>> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres >>> : >>> postgres=CTc/postgres >>> (4 rows) >>> >>> >>> Note: The 10.0.0.132 is my puppetmaster and server puppetdb with postgres . >>> ¿Is possible that the information is stored elsewhere? >>> >>> Thanks!! >>> >>> El 21-08-2013, a las 18:39, Ellison Marks <[email protected]> escribió: >>> >>> psql -h 127.0.0.1 puppetdb puppetdb >>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Puppet Users" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/puppet-users. >>> For more options, visit https://groups.google.com/groups/opt_out. >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Puppet Users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/puppet-users/ELg35FS1fZg/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/puppet-users. >> For more options, visit https://groups.google.com/groups/opt_out. > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/puppet-users. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
