Re: [GENERAL] Re: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump?
Jasen Betts wrote: On 2009-02-10, Jonathan Vanasco wrote: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump? i think i just need a METHOD for localhost only. write a script that sets PGPASSWORD and then calls pg_dump, use .pgconf, or use trust or ident authenticateion in pg_hba.conf i think this site will help you out http://www.postgresql.org/docs/8.3/static/auth-pg-hba-conf.html Regards kusuma.p -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] hi all
when creating tables, in my sql i have used create table CREATE TABLE `users` ( `user_id` int(11) NOT NULL auto_increment, `user_name` varchar(50) NOT NULL, `first_name` varchar(50) default NULL, `middle_name` varchar(50) default NULL, `last_name` varchar(50) default NULL, `password` varchar(50) default NULL, `salt` varchar(50) default NULL, `secret_question` varchar(255) default NULL, `secret_answer` varchar(255) default NULL, `creator` int(11) default NULL, `date_created` datetime NOT NULL default '-00-00 00:00:00', `changed_by` int(11) default NULL, `date_changed` datetime default NULL, `voided` tinyint(1) NOT NULL default '0', `voided_by` int(11) default NULL, `date_voided` datetime default NULL, `void_reason` varchar(255) default NULL, PRIMARY KEY (`user_id`), KEY `users_user_creator` (`creator`), KEY `users_user_who_changed_user` (`changed_by`), KEY `users_user_who_voided_user` (`voided_by`), CONSTRAINT `users_user_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), CONSTRAINT `users_user_who_changed_user` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`), CONSTRAINT `users_user_who_voided_user` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; while in pgsql i am thinking of to use the same as follows: CREATE TABLE users ( user_id int(11) NOT NULL serial, user_name varchar(50) NOT NULL, first_name varchar(50) default NULL, middle_name varchar(50) default NULL, last_name varchar(50) default NULL, password varchar(50) default NULL, salt varchar(50) default NULL, secret_question varchar(255) default NULL, secret_answer varchar(255) default NULL, creator int(11) default NULL, date_created datetime NOT NULL default '-00-00 00:00:00', changed_by int(11) default NULL, date_changed datetime default NULL, voided smallint(1) NOT NULL default '0', voided_by int(11) default NULL, date_voided datetime default NULL, void_reason varchar(255) default NULL, PRIMARY KEY (user_id), KEY users_user_creator (creator), KEY users_user_who_changed_user (changed_by), KEY users_user_who_voided_user (voided_by), CONSTRAINT users_user_creator FOREIGN KEY (creator) REFERENCES users (user_id), CONSTRAINT users_user_who_changed_user FOREIGN KEY (changed_by) REFERENCES users (user_id), CONSTRAINT users_user_who_voided_user FOREIGN KEY (voided_by) REFERENCES users (user_id) ) ; will that be valid to create a table like this if no what all have to be replaced thanks for any help Regards kusuma.p -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] password for postgres
i don't know y am i getting this problem when i try to start off postgres it asks me for password: i did not set any password as such except that when the first day i used template, i ahve used the below two statements ALTER USER postgres with encrypted password 'your_password'; ALTER USER postgres with encrypted password 'welcome'; but it is not accepting both the passwords i am getting incorrect password after three trials it is returning back to command prompt when i have used select * from pg_shadow; then i got md5d31faa0b92fad4e2d8e4af34a30f890b though i use this i am not able to acess i don't know what to do with this issue can any one shed light on me by explaining me what was the mistake i did or which password to use thanks for any help Regards kusuma.p -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] small doubt
what does postgres management gui mean ? How is it useful ? can i have it on ubuntu? Thanks & Regards kusuma.p -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] creating tables using a file
hello all, i have used a file containing all the queries and directly executed the file to create tables in mysql, now i want to use the same for psql is it possible? if yes how? Do i need to make any changes to the file? Thanks for any help Regards kusuma.p -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] small doubt
when i use /usr/local/pgsql/bin/psql test this i am getting following error psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? should i restart the server or what should be done for this how can i resolve this issue Thanks & Regards kusuma.p -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] running postgres
may this be a silly doubts but , i am new to postgres, please answer to these:: /usr/local/pgsql/bin/psql test test=# sudo su postgres -c psql template1 template=# what is the difference between the above two and, why is the path different in both cases which should i use now how can i create a user in test or template when i give create user it is asking for create role , how should i create role? Thanks & Regards kusuma.p -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] installation
Hello all, i am new to postgresql, i want to create tables in this i have followed 10 Steps to Installing PostgreSQL which is chapter two of installing postgresql i could follow upto step no 7 but i am getting errors from step 8 while following the steps i got message like postgresql is sucessfully installed now my doubt if it is installed, how should i start working on it i used sudo su postgres -c psql template1 password for my super user:** then the prompt changed to postgres=# what does this implies can i start working on that or do i have to modify furthur sorry for such a long mail and Thanks for any help!!! Thanks & Regards kusuma.p -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general