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 / 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 create implicit index >>> "dispatcher_pkey" for table "dispatcher" >>> Password for user postgres: >>> NOTICE: CREATE TABLE will create implicit sequence "dialplan_id_seq" >>> for serial column "dialplan.id" >>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>> "dialplan_pkey" for table "dialplan" >>> Password for user postgres: >>> NOTICE: CREATE TABLE will create implicit sequence "dr_gateways_id_seq" >>> for serial column "dr_gateways.id" >>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>> "dr_gateways_pkey" for table "dr_gateways" >>> NOTICE: CREATE TABLE / UNIQUE will create implicit index >>> "dr_gateways_dr_gw_idx" for table "dr_gateways" >>> NOTICE: CREATE TABLE will create implicit sequence >>> "dr_rules_ruleid_seq" for serial column "dr_rules.ruleid" >>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>> "dr_rules_pkey" for table "dr_rules" >>> NOTICE: CREATE TABLE will create implicit sequence "dr_carriers_id_seq" >>> for serial column "dr_carriers.id" >>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>> "dr_carriers_pkey" for table "dr_carriers" >>> NOTICE: CREATE TABLE / UNIQUE will create implicit index >>> "dr_carriers_dr_carrier_idx" for table "dr_carriers" >>> NOTICE: CREATE TABLE will create implicit sequence "dr_groups_id_seq" >>> for serial column "dr_groups.id" >>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>> "dr_groups_pkey" for table "dr_groups" >>> Password for user postgres: >>> NOTICE: CREATE TABLE will create implicit sequence >>> "load_balancer_id_seq" for serial column "load_balancer.id" >>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>> "load_balancer_pkey" for table "load_balancer" >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> Password for user postgres: >>> >>> >>> _______________________________________________ >>> Users mailing list >>> Users@lists.opensips.org >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >>> >> >> >> -- >> 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 list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users