[newbie] postgresql problems
I'm trying to install Cubit which requires postgresql. But I keep getting this error: psql: FATAL: IDENT authentication failed for user pguser when I type psql -U pguser I've googled on the error and made changes to pg_ident.conf and pg_hba.conf as suggested but I still get the error, even thought I restarted the service. I also followed this howto: HOWTO use the PostgreSQL server in few steps by Christian Belisle [EMAIL PROTECTED] This file is included with the Mandrake PostgreSQL's packages. After you installed the packages, here is the procedure to start quickly but nicely. 1- Become root user on your machine. (su) 2- Become postgres user. (su postgres) 3- Create a user (createuser) 4- Be sure that the postmaster is running (service postgresql status) 5- Logout from the postgres and the root account. 6- Test it. (psql -U [username]) I'm actually surprised at how difficult this is to setup. Or more accurately, I'm surprised at how hard it is to get the info. Thanks folks, Jarlath -- Copyrighting allows people to benefit from their labours, but software patents allow the companies with the largest legal departments to benefit from everyone else's work. Andrew Brown, The Guardian. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] PostgreSQL
At 08:40 AM 3/25/03, Christopher Shaffer wrote: Forgive my silly question, but I'm trying to experiment with PostgreSQL (all I've used till now is MySQL...) on Mandrake 9.0, but I have know idea what the default username/password is. Is it kind of like MySQL, with a root user? Could be postgres or pgsql - look in /etc/passwd for userid's starting with 'p'. if you 'su' to root, then you won't be asked for passwd switching to pgsql admin (or even change the password of that account). As pgsql admin, use createuser and createdb commands to create a user and database, then use these thereafter. If user and database have the same name, then that user simply enters 'pgsql' to get an interactive session. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
RE: [newbie] PostgreSQL
To access postgresql (assuming everything has been set up correctly).. 1. $su postgres from su. 2. createuser -e --pwprompt user (where user is the name your using) Enter password for user user:* Enter it again: Shall the new user be allowed to create database? (y/n) Shall the new user be allowed to create more new users? (y/n)n CREATE USER user . Since I don't like using postgres as my standard user this does the ticket for creating a semi Postgresql admin. Also make sure in your in your pg_hba.conf file that you add the following line. host all (ip address optional)(mask optional) ident sameuser If you have configured your postgresql.conf file correctly you can access the db from other computers with pgadmin or another pgsql session. cheers neenja -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Christopher Shaffer Sent: Tuesday, March 25, 2003 5:41 AM To: [EMAIL PROTECTED] Subject: [newbie] PostgreSQL Forgive my silly question, but I'm trying to experiment with PostgreSQL (all I've used till now is MySQL...) on Mandrake 9.0, but I have know idea what the default username/password is. Is it kind of like MySQL, with a root user? Thanks, Chris __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] PostgreSQL
Forgive my silly question, but I'm trying to experiment with PostgreSQL (all I've used till now is MySQL...) on Mandrake 9.0, but I have know idea what the default username/password is. Is it kind of like MySQL, with a root user? Thanks, Chris __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] PostgreSQL
it's probably postgres. If there is a password allocated as well and you don't know what it is, (blowed if I can remember) try su root then su postgres :o) As postgres you are the main postgresql user and can create other users - including yourself. There are huge volumes of notes available with the package and from the site. regards Daryl On Tuesday 25 Mar 2003 1:40 pm, Christopher Shaffer wrote: Forgive my silly question, but I'm trying to experiment with PostgreSQL (all I've used till now is MySQL...) on Mandrake 9.0, but I have know idea what the default username/password is. Is it kind of like MySQL, with a root user? Thanks, Chris __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- It's NO USE ... I've gone to CLUB MED!! Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] postgresql - changing location of db/cluster
mandrake automatically creates the postgres db/cluster in /var/lib/pgsql/data and automatically starts the db/cluster. what changes would one need to do if wanting to change the installation of the db/cluster (e.g. to /var/db/postgres/data)? would the following suffice? -stop the postgres service -delete /var/lib/pgsql/data -set the PGDATA env to /var/db/postgres/data in /etc/profile -initdb -D /var/db/postgres/data -restart the postgres service also, must a postgres user account be created when setting up a new db/cluster using initdb? can any user account be used? if so, what settings/permissions (if any) must be changed? thanks. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] postgresql
Getting started with PostgreSQL. I have never used a database program and know very little about this. I would like to install PostgreSQL on my 8.1 system, to begin learning how to work with it and develop a simple database. I have a number of questions as to how to get started. 1) Although PostgreSQL is not yet installed on my system, there is a user account that already seems to have been created on install by the name of postgres. Currently it has no passwd, and is only accessible through root. Is this the user account I should use to work with PostgreSQL, is that what this is there for? 2) Would it be more beneficial for me at this moment in time to install PostgreSQL from the Mandrake cds, or attempt an install from source? 3) I do not want to open myself to security issues. My database is for internal use only. Will installing PostgreSQL start any servers or potentially compromisable services by default? If so, how can I turn these off, or should I? I know these are a lot of questions to dump on the group, this sort of stuff is even before what is covered in the tutorials. Thanks, everybody. -Paul Rodríguez _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
RE: [newbie] postgresql
Answer to one : Postgres is the user account that the postgres DBMS in run as a service. You can create a user account for yourself from the command line using createuser Synopsis createuser [options...] [username] Inputs -h, --host host Specifies the hostname of the machine on which the postmaster is running. If host begins with a slash, it is used as the directory for the unix domain socket. -p, --port port Specifies the Internet TCP/IP port or local Unix domain socket file extension onwhich the postmaster is listening for connections. -e, --echo Echo the queries that createdb generates and sends to the backend. -q, --quiet Do not display a response. -d, --createdb Allows the new user to create databases. -D, --no-createdb Forbids the new user to create databases. -a, --adduser Allows the new user to create other users. -A, --no-adduser Forbids the new user to create other users. to use this created user to access the DB use : psql [ options ] [ dbname [ user ] ] you will be prompted for the user password (I think, I have not had to access the Db from the CLI since I put up my Zope front end application ;-) ) Answer to two : I installed and ran it from extensiont cd of LM 8.0 and it ran ok. Answer to three : Check the Security Gurus -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Rodríguez Sent: Saturday, October 20, 2001 10:30 AM To: newbie Subject: [newbie] postgresql Getting started with PostgreSQL. I have never used a database program and know very little about this. I would like to install PostgreSQL on my 8.1 system, to begin learning how to work with it and develop a simple database. I have a number of questions as to how to get started. 1) Although PostgreSQL is not yet installed on my system, there is a user account that already seems to have been created on install by the name of postgres. Currently it has no passwd, and is only accessible through root. Is this the user account I should use to work with PostgreSQL, is that what this is there for? 2) Would it be more beneficial for me at this moment in time to install PostgreSQL from the Mandrake cds, or attempt an install from source? 3) I do not want to open myself to security issues. My database is for internal use only. Will installing PostgreSQL start any servers or potentially compromisable services by default? If so, how can I turn these off, or should I? I know these are a lot of questions to dump on the group, this sort of stuff is even before what is covered in the tutorials. Thanks, everybody. -Paul Rodríguez _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] PostgreSQL -- Database
I have Mandrake 7.0 and I have been trying to gety PostgreSQl running but unsuccesfully. If I type 'psql', i get connection refused. if i type postmaster, i get 'postmaster doesnt know where to find database system data...' any ideas? Neri