Hi, Needed clarification on the procedure for adding a new table to postgres database in the sipX ede. These are the steps that I followed: 1.Made the changes to the sql file for adding a table. 2.Used the following commands: >/etc/init.d/postgresql initdb (It said "Data directory is not empty! [FAILED]") So I followed the procedure to remove the Data directory as mentioned in section 'Clears all postgres databases' in link http://sipx-wiki.calivia.com/index.php/SipX_ConfigServer_Troubleshooting #Postgresql_server_not_running_or_missconfigured That is, these commands: >service postgresql stop >rm -rf /var/lib/pgsql/data >su - postgres -c "initdb /var/lib/pgsql/data" >./INSTALL/bin/sipxconfig.sh --setup This works(new table gets created) but as known all the configurations are lost. Is there a better way to add a new table?
Thanks & Regards, Seshu
_______________________________________________ sipx-dev mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-dev Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-dev sipXecs IP PBX -- http://www.sipfoundry.org/
