Seshu-Babu Kollipara wrote:
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?
------------------------------------------------------------------------
Please see
http://sipx-wiki.calivia.com/index.php/SipX_ConfigServer_How_to_change_database_schema
Laurentiu
_______________________________________________
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/
