yes , it is . i forget how to do it . you just need to a connection information in the wms configuration file
From: José Pedro Santos <zpsantos1@hotmail.com> To: Postgres Ajuda <pgsql-general@postgresql.org> Sent: Friday, October 12, 2012 5:46 PM Subject: [GENERAL] PostgreSQL and WMS
Dear all,
I would like to know if is possible set up a service (WMS/WFS) for a layer stored within Postgres.
I have one WEBGIS application that can't connect to PostgreSQL but if I use the data inside Postgres I can get the URL from WMS and add the maps.