[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 post

[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 c

[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

[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 ma

[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] 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

[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` varcha

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 trus