Re: [OpenSIPS-Users] opensips 1.11 postgress DB BUG
Hey Liviu, I have fixed script here is the pull request https://github.com/OpenSIPS/opensips/pull/476 On Wed, Apr 22, 2015 at 8:27 AM, Liviu Chircu li...@opensips.org wrote: Hi Aron/Satish, If you can put together a working Pull Request, I will gladly review it. If bash is not your strong suite, then could you please open a Bug Report [1]? Sooner or later, it will get solved :) [1] https://github.com/OpenSIPS/opensips/issues?q=is%3Aopen+is%3Aissue+label%3Abug Best regards, Liviu Chircu OpenSIPS Developerhttp://www.opensips-solutions.com On 21.04.2015 23:30, Podrigal, Aron wrote: MySQL has a option --password to provide the password on command line. postgres however does not. but here is some refs how you can accomplish what you would like. http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html On Tue, Apr 21, 2015 at 4:26 PM, Satish Patel satish@gmail.com wrote: can't we make password less? just like MySQL? On Tue, Apr 21, 2015 at 1:56 PM, Podrigal, Aron ar...@guaranteedplus.com wrote: It executes a series of sql files ( I don't remember the dir location where its stored I think somewhere in the share dir) for each file it asks for the password. On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel satish@gmail.com wrote: I am installing opensips 1.11.3 with postgress DB but i don't know what is going on here root@dopensips:/etc/opensips# opensipsdbctl create INFO: creating database opensips ... Password for user postgres: Password for user postgres: Password for user postgres: NOTICE: CREATE TABLE / UNIQUE will create implicit index version_t_name_idx for table version Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence acc_id_seq for serial column acc.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index acc_pkey for table acc NOTICE: CREATE TABLE will create implicit sequence missed_calls_id_seq for serial column missed_calls.id -- Aron Podrigal - //Be happy :-) ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Aron Podrigal - //Be happy :-) ___ Users mailing listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] opensips 1.11 postgress DB BUG
I just did for 1.11 branch, if you want i can do same for 2.1 latest branch On Wed, Apr 22, 2015 at 2:32 PM, Satish Patel satish@gmail.com wrote: Hey Liviu, I have fixed script here is the pull request https://github.com/OpenSIPS/opensips/pull/476 On Wed, Apr 22, 2015 at 8:27 AM, Liviu Chircu li...@opensips.org wrote: Hi Aron/Satish, If you can put together a working Pull Request, I will gladly review it. If bash is not your strong suite, then could you please open a Bug Report [1]? Sooner or later, it will get solved :) [1] https://github.com/OpenSIPS/opensips/issues?q=is%3Aopen+is%3Aissue+label%3Abug Best regards, Liviu Chircu OpenSIPS Developerhttp://www.opensips-solutions.com On 21.04.2015 23:30, Podrigal, Aron wrote: MySQL has a option --password to provide the password on command line. postgres however does not. but here is some refs how you can accomplish what you would like. http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html On Tue, Apr 21, 2015 at 4:26 PM, Satish Patel satish@gmail.com wrote: can't we make password less? just like MySQL? On Tue, Apr 21, 2015 at 1:56 PM, Podrigal, Aron ar...@guaranteedplus.com wrote: It executes a series of sql files ( I don't remember the dir location where its stored I think somewhere in the share dir) for each file it asks for the password. On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel satish@gmail.com wrote: I am installing opensips 1.11.3 with postgress DB but i don't know what is going on here root@dopensips:/etc/opensips# opensipsdbctl create INFO: creating database opensips ... Password for user postgres: Password for user postgres: Password for user postgres: NOTICE: CREATE TABLE / UNIQUE will create implicit index version_t_name_idx for table version Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence acc_id_seq for serial column acc.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index acc_pkey for table acc NOTICE: CREATE TABLE will create implicit sequence missed_calls_id_seq for serial column missed_calls.id -- Aron Podrigal - //Be happy :-) ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Aron Podrigal - //Be happy :-) ___ Users mailing listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] opensips 1.11 postgress DB BUG
I am installing opensips 1.11.3 with postgress DB but i don't know what is going on here root@dopensips:/etc/opensips# opensipsdbctl create INFO: creating database opensips ... Password for user postgres: Password for user postgres: Password for user postgres: NOTICE: CREATE TABLE / UNIQUE will create implicit index version_t_name_idx for table version Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence acc_id_seq for serial column acc.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index acc_pkey for table acc NOTICE: CREATE TABLE will create implicit sequence missed_calls_id_seq for serial column missed_calls.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index missed_calls_pkey for table missed_calls Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence domain_id_seq for serial column domain.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index domain_pkey for table domain NOTICE: CREATE TABLE / UNIQUE will create implicit index domain_domain_idx for table domain Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence grp_id_seq for serial column grp.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index grp_pkey for table grp NOTICE: CREATE TABLE / UNIQUE will create implicit index grp_account_group_idx for table grp NOTICE: CREATE TABLE will create implicit sequence re_grp_id_seq for serial column re_grp.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index re_grp_pkey for table re_grp Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence address_id_seq for serial column address.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index address_pkey for table address Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence aliases_id_seq for serial column aliases.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index aliases_pkey for table aliases NOTICE: CREATE TABLE / UNIQUE will create implicit index aliases_alias_idx for table aliases Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence location_id_seq for serial column location.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index location_pkey for table location NOTICE: CREATE TABLE / UNIQUE will create implicit index location_account_contact_idx for table location Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence silo_id_seq for serial column silo.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index silo_pkey for table silo Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence dbaliases_id_seq for serial column dbaliases.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index dbaliases_pkey for table dbaliases NOTICE: CREATE TABLE / UNIQUE will create implicit index dbaliases_alias_idx for table dbaliases Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence uri_id_seq for serial column uri.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index uri_pkey for table uri NOTICE: CREATE TABLE / UNIQUE will create implicit index uri_account_idx for table uri Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence rtpproxy_sockets_id_seq for serial column rtpproxy_sockets.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index rtpproxy_sockets_pkey for table rtpproxy_sockets Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence speed_dial_id_seq for serial column speed_dial.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index speed_dial_pkey for table speed_dial NOTICE: CREATE TABLE / UNIQUE will create implicit index speed_dial_speed_dial_idx for table speed_dial Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence usr_preferences_id_seq for serial column usr_preferences.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index usr_preferences_pkey for table usr_preferences Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence subscriber_id_seq for serial column subscriber.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index subscriber_pkey for table subscriber NOTICE: CREATE TABLE / UNIQUE will create implicit index subscriber_account_idx for table subscriber Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence pdt_id_seq for serial column pdt.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index pdt_pkey for table pdt NOTICE: CREATE TABLE / UNIQUE will create implicit index pdt_sdomain_prefix_idx for table pdt Password for user postgres: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index dialog_pkey for table dialog Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence dispatcher_id_seq for serial column dispatcher.id NOTICE: CREATE TABLE / PRIMARY KEY will
Re: [OpenSIPS-Users] opensips 1.11 postgress DB BUG
It executes a series of sql files ( I don't remember the dir location where its stored I think somewhere in the share dir) for each file it asks for the password. On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel satish@gmail.com wrote: I am installing opensips 1.11.3 with postgress DB but i don't know what is going on here root@dopensips:/etc/opensips# opensipsdbctl create INFO: creating database opensips ... Password for user postgres: Password for user postgres: Password for user postgres: NOTICE: CREATE TABLE / UNIQUE will create implicit index version_t_name_idx for table version Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence acc_id_seq for serial column acc.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index acc_pkey for table acc NOTICE: CREATE TABLE will create implicit sequence missed_calls_id_seq for serial column missed_calls.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index missed_calls_pkey for table missed_calls Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence domain_id_seq for serial column domain.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index domain_pkey for table domain NOTICE: CREATE TABLE / UNIQUE will create implicit index domain_domain_idx for table domain Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence grp_id_seq for serial column grp.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index grp_pkey for table grp NOTICE: CREATE TABLE / UNIQUE will create implicit index grp_account_group_idx for table grp NOTICE: CREATE TABLE will create implicit sequence re_grp_id_seq for serial column re_grp.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index re_grp_pkey for table re_grp Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence address_id_seq for serial column address.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index address_pkey for table address Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence aliases_id_seq for serial column aliases.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index aliases_pkey for table aliases NOTICE: CREATE TABLE / UNIQUE will create implicit index aliases_alias_idx for table aliases Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence location_id_seq for serial column location.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index location_pkey for table location NOTICE: CREATE TABLE / UNIQUE will create implicit index location_account_contact_idx for table location Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence silo_id_seq for serial column silo.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index silo_pkey for table silo Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence dbaliases_id_seq for serial column dbaliases.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index dbaliases_pkey for table dbaliases NOTICE: CREATE TABLE / UNIQUE will create implicit index dbaliases_alias_idx for table dbaliases Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence uri_id_seq for serial column uri.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index uri_pkey for table uri NOTICE: CREATE TABLE / UNIQUE will create implicit index uri_account_idx for table uri Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence rtpproxy_sockets_id_seq for serial column rtpproxy_sockets.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index rtpproxy_sockets_pkey for table rtpproxy_sockets Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence speed_dial_id_seq for serial column speed_dial.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index speed_dial_pkey for table speed_dial NOTICE: CREATE TABLE / UNIQUE will create implicit index speed_dial_speed_dial_idx for table speed_dial Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence usr_preferences_id_seq for serial column usr_preferences.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index usr_preferences_pkey for table usr_preferences Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence subscriber_id_seq for serial column subscriber.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index subscriber_pkey for table subscriber NOTICE: CREATE TABLE / UNIQUE will create implicit index subscriber_account_idx for table subscriber Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence pdt_id_seq for serial column pdt.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index pdt_pkey for table pdt NOTICE: CREATE TABLE / UNIQUE will create
Re: [OpenSIPS-Users] opensips 1.11 postgress DB BUG
can't we make password less? just like MySQL? On Tue, Apr 21, 2015 at 1:56 PM, Podrigal, Aron ar...@guaranteedplus.com wrote: It executes a series of sql files ( I don't remember the dir location where its stored I think somewhere in the share dir) for each file it asks for the password. On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel satish@gmail.com wrote: I am installing opensips 1.11.3 with postgress DB but i don't know what is going on here root@dopensips:/etc/opensips# opensipsdbctl create INFO: creating database opensips ... Password for user postgres: Password for user postgres: Password for user postgres: NOTICE: CREATE TABLE / UNIQUE will create implicit index version_t_name_idx for table version Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence acc_id_seq for serial column acc.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index acc_pkey for table acc NOTICE: CREATE TABLE will create implicit sequence missed_calls_id_seq for serial column missed_calls.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index missed_calls_pkey for table missed_calls Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence domain_id_seq for serial column domain.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index domain_pkey for table domain NOTICE: CREATE TABLE / UNIQUE will create implicit index domain_domain_idx for table domain Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence grp_id_seq for serial column grp.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index grp_pkey for table grp NOTICE: CREATE TABLE / UNIQUE will create implicit index grp_account_group_idx for table grp NOTICE: CREATE TABLE will create implicit sequence re_grp_id_seq for serial column re_grp.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index re_grp_pkey for table re_grp Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence address_id_seq for serial column address.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index address_pkey for table address Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence aliases_id_seq for serial column aliases.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index aliases_pkey for table aliases NOTICE: CREATE TABLE / UNIQUE will create implicit index aliases_alias_idx for table aliases Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence location_id_seq for serial column location.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index location_pkey for table location NOTICE: CREATE TABLE / UNIQUE will create implicit index location_account_contact_idx for table location Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence silo_id_seq for serial column silo.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index silo_pkey for table silo Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence dbaliases_id_seq for serial column dbaliases.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index dbaliases_pkey for table dbaliases NOTICE: CREATE TABLE / UNIQUE will create implicit index dbaliases_alias_idx for table dbaliases Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence uri_id_seq for serial column uri.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index uri_pkey for table uri NOTICE: CREATE TABLE / UNIQUE will create implicit index uri_account_idx for table uri Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence rtpproxy_sockets_id_seq for serial column rtpproxy_sockets.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index rtpproxy_sockets_pkey for table rtpproxy_sockets Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence speed_dial_id_seq for serial column speed_dial.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index speed_dial_pkey for table speed_dial NOTICE: CREATE TABLE / UNIQUE will create implicit index speed_dial_speed_dial_idx for table speed_dial Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence usr_preferences_id_seq for serial column usr_preferences.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index usr_preferences_pkey for table usr_preferences Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence subscriber_id_seq for serial column subscriber.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index subscriber_pkey for table subscriber NOTICE: CREATE TABLE / UNIQUE will create implicit index subscriber_account_idx for table subscriber Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence pdt_id_seq for serial column pdt.id
Re: [OpenSIPS-Users] opensips 1.11 postgress DB BUG
MySQL has a option --password to provide the password on command line. postgres however does not. but here is some refs how you can accomplish what you would like. http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html On Tue, Apr 21, 2015 at 4:26 PM, Satish Patel satish@gmail.com wrote: can't we make password less? just like MySQL? On Tue, Apr 21, 2015 at 1:56 PM, Podrigal, Aron ar...@guaranteedplus.com wrote: It executes a series of sql files ( I don't remember the dir location where its stored I think somewhere in the share dir) for each file it asks for the password. On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel satish@gmail.com wrote: I am installing opensips 1.11.3 with postgress DB but i don't know what is going on here root@dopensips:/etc/opensips# opensipsdbctl create INFO: creating database opensips ... Password for user postgres: Password for user postgres: Password for user postgres: NOTICE: CREATE TABLE / UNIQUE will create implicit index version_t_name_idx for table version Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence acc_id_seq for serial column acc.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index acc_pkey for table acc NOTICE: CREATE TABLE will create implicit sequence missed_calls_id_seq for serial column missed_calls.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index missed_calls_pkey for table missed_calls Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence domain_id_seq for serial column domain.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index domain_pkey for table domain NOTICE: CREATE TABLE / UNIQUE will create implicit index domain_domain_idx for table domain Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence grp_id_seq for serial column grp.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index grp_pkey for table grp NOTICE: CREATE TABLE / UNIQUE will create implicit index grp_account_group_idx for table grp NOTICE: CREATE TABLE will create implicit sequence re_grp_id_seq for serial column re_grp.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index re_grp_pkey for table re_grp Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence address_id_seq for serial column address.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index address_pkey for table address Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence aliases_id_seq for serial column aliases.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index aliases_pkey for table aliases NOTICE: CREATE TABLE / UNIQUE will create implicit index aliases_alias_idx for table aliases Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence location_id_seq for serial column location.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index location_pkey for table location NOTICE: CREATE TABLE / UNIQUE will create implicit index location_account_contact_idx for table location Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence silo_id_seq for serial column silo.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index silo_pkey for table silo Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence dbaliases_id_seq for serial column dbaliases.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index dbaliases_pkey for table dbaliases NOTICE: CREATE TABLE / UNIQUE will create implicit index dbaliases_alias_idx for table dbaliases Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence uri_id_seq for serial column uri.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index uri_pkey for table uri NOTICE: CREATE TABLE / UNIQUE will create implicit index uri_account_idx for table uri Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence rtpproxy_sockets_id_seq for serial column rtpproxy_sockets.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index rtpproxy_sockets_pkey for table rtpproxy_sockets Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence speed_dial_id_seq for serial column speed_dial.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index speed_dial_pkey for table speed_dial NOTICE: CREATE TABLE / UNIQUE will create implicit index speed_dial_speed_dial_idx for table speed_dial Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence usr_preferences_id_seq for serial column usr_preferences.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index usr_preferences_pkey for table usr_preferences Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence subscriber_id_seq for serial column subscriber.id NOTICE: CREATE TABLE