pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNew to PostgreSQL
10+ messages / 10 participants
[nested] [flat]
* New to PostgreSQL
@ 2006-11-01 19:39 Mark Steben <msteben@autorevenue.com>
0 siblings, 2 replies; 10+ messages in thread
From: Mark Steben @ 2006-11-01 19:39 UTC (permalink / raw)
To: pgsql-admin
Good afternoon,
I am a database administrator who has worked with mainframe DB2 databases
for 16 years. I am brand new to PostgreSQL. I just started a new job where
I am the only DBA in the company and am expected to ramp up as soon as
possible. Are there any courses available to me - either self-taught or
Classroom - that could provide me with a broad-brush introduction? Right
now my main resource is the PostgreSQL - The Comprehensive Guide,
By Korry and Susan Douglas - a very good reference that I am using as I
tackle specific tasks. I think a good overview would help me as I basically
Self-educate.
Thank you and I look forward to working with you through your mailing list.
Mark Steben
AutoRevenue
Lee, Massachusetts
MSteben@autorevenue.com
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: New to PostgreSQL
@ 2006-11-02 07:44 Shoaib Mir <shoaibmir@gmail.com>
parent: Mark Steben <msteben@autorevenue.com>
1 sibling, 1 reply; 10+ messages in thread
From: Shoaib Mir @ 2006-11-02 07:44 UTC (permalink / raw)
To: Mark Steben <msteben@autorevenue.com>; +Cc: pgsql-admin
Another very good resource is the PostgreSQL documentation itself -->
http://www.postgresql.org/docs/8.1/static/index.html
Thanks,
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 11/2/06, Mark Steben <msteben@autorevenue.com> wrote:
>
> Good afternoon,
>
>
>
> I am a database administrator who has worked with mainframe DB2 databases
> for 16 years. I am brand new to PostgreSQL. I just started a new job where
>
> I am the only DBA in the company and am expected to ramp up as soon as
> possible. Are there any courses available to me - either self-taught or
>
> Classroom - that could provide me with a broad-brush introduction? Right
> now my main resource is the *PostgreSQL - The Comprehensive Guide*,
>
> By Korry and Susan Douglas - a very good reference that I am using as I
> tackle specific tasks. I think a good overview would help me as I basically
>
> Self-educate.
>
>
>
> Thank you and I look forward to working with you through your mailing
> list.
>
>
>
> Mark Steben
>
> AutoRevenue
>
> Lee, Massachusetts
>
> MSteben@autorevenue.com
>
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: New to PostgreSQL
@ 2006-11-02 08:13 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Mark Steben <msteben@autorevenue.com>
1 sibling, 1 reply; 10+ messages in thread
From: Achilleas Mantzios @ 2006-11-02 08:13 UTC (permalink / raw)
To: pgsql-admin
Óôéò ÔåôÜñôç 01 ÍïÝìâñéïò 2006 21:39, ï/ç Mark Steben Ýãñáøå:
> Good afternoon,
>
>
>
> I am a database administrator who has worked with mainframe DB2 databases
> for 16 years. I am brand new to PostgreSQL. I just started a new job
> where
>
Welcome to postgresql camp!
i was MVS, os/390,... "sysprog" myself for 4 years (until i realized that i
had to return to the real thing (unix) asap, so i left the job in the bank).
I think, apart from postgresql you gotta get familiar with the linux/*bsd/unix
concepts as well, as sometimes performance has to do with OS tuning too.
Features/concepts wise, i dont think you'll face big problems, since
you are coming from a rich rdbms.
> I am the only DBA in the company and am expected to ramp up as soon as
> possible. Are there any courses available to me - either self-taught or
>
> Classroom - that could provide me with a broad-brush introduction? Right
> now my main resource is the PostgreSQL - The Comprehensive Guide,
>
> By Korry and Susan Douglas - a very good reference that I am using as I
> tackle specific tasks. I think a good overview would help me as I
> basically
>
> Self-educate.
>
>
>
> Thank you and I look forward to working with you through your mailing list.
>
>
>
> Mark Steben
>
> AutoRevenue
>
> Lee, Massachusetts
>
> MSteben@autorevenue.com
--
Achilleas Mantzios
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: New to PostgreSQL
@ 2006-11-02 16:08 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 10+ messages in thread
From: Andrew Sullivan @ 2006-11-02 16:08 UTC (permalink / raw)
To: pgsql-admin
On Thu, Nov 02, 2006 at 11:13:24AM +0300, Achilleas Mantzios wrote:
>
> I think, apart from postgresql you gotta get familiar with the linux/*bsd/unix
> concepts as well, as sometimes performance has to do with OS tuning too.
Let me echo that, because it's extremely important: when I was in
charge of hiring people to work on our databases, I was very
concerned not to get the sort of people who felt that the system was
"the sysadmin's problem". You _cannot_ treat the operating system as
not your problem when addressing performance questions in PostgreSQL.
This is a very unfamiliar situation to most Oracle and some DB2
administrators, in my experience. The good ones, of course, have no
problem catching on; the bad ones never deserved the name DBA anyway
;-)
A
--
Andrew Sullivan | ajs@crankycanuck.ca
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of code underneath."
--Damien Katz
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: New to PostgreSQL
@ 2006-11-03 19:40 Tomeh, Husam <htomeh@firstam.com>
parent: Shoaib Mir <shoaibmir@gmail.com>
0 siblings, 0 replies; 10+ messages in thread
From: Tomeh, Husam @ 2006-11-03 19:40 UTC (permalink / raw)
To: Shoaib Mir <shoaibmir@gmail.com>; Mark Steben <msteben@autorevenue.com>; +Cc: pgsql-admin
The docs is definitely a great and easy to read resource. If you're
looking for a class, you can check out the OTG group:
http://www.otg-nc.com/training-courses/coursedetail.php?courseid=40&cat_
id=8
An online Postgres book (practical postgresql) can also be found at
http://www.faqs.org/docs/ppbook/book1.htm
For other useful related URLs, check out,
http://firstdba.googlepages.com/rdbmsportal-postgresqlpage
--
Husam
________________________________
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Shoaib Mir
Sent: Wednesday, November 01, 2006 11:45 PM
To: Mark Steben
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] New to PostgreSQL
Another very good resource is the PostgreSQL documentation itself -->
http://www.postgresql.org/docs/8.1/static/index.html
Thanks,
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 11/2/06, Mark Steben < msteben@autorevenue.com
<mailto:msteben@autorevenue.com> > wrote:
Good afternoon,
I am a database administrator who has worked with mainframe DB2
databases for 16 years. I am brand new to PostgreSQL. I just started a
new job where
I am the only DBA in the company and am expected to ramp up as
soon as possible. Are there any courses available to me - either
self-taught or
Classroom - that could provide me with a broad-brush
introduction? Right now my main resource is the PostgreSQL - The
Comprehensive Guide,
By Korry and Susan Douglas - a very good reference that I am
using as I tackle specific tasks. I think a good overview would help me
as I basically
Self-educate.
Thank you and I look forward to working with you through your
mailing list.
Mark Steben
AutoRevenue
Lee, Massachusetts
MSteben@autorevenue.com
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged. If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.
Thank you.
FADLD Tag
**********************************************************************
^ permalink raw reply [nested|flat] 10+ messages in thread
* New to postgreSQL
@ 2017-09-04 14:11 Ramesh <ramesh4f@gmail.com>
0 siblings, 2 replies; 10+ messages in thread
From: Ramesh @ 2017-09-04 14:11 UTC (permalink / raw)
To: pgsql-admin
HI all
Im new to postgres.
I tried to create user with the command createuser from outside the
psql client. But got the below error.
Based on tutorial, I could see the createuser <<username>> gets created,
but while login it will throw error. My case is like below.
[postgres@localhost ~]$ createuser mytest
Password:
createuser: could not connect to database postgres: FATAL: password
authentication failed for user "postgres"
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: New to postgreSQL
@ 2017-09-04 14:28 SEKA Bruno-Emmanuel <master.ematris@gmail.com>
parent: Ramesh <ramesh4f@gmail.com>
1 sibling, 0 replies; 10+ messages in thread
From: SEKA Bruno-Emmanuel @ 2017-09-04 14:28 UTC (permalink / raw)
To: Ramesh <ramesh4f@gmail.com>; +Cc: pgsql-admin
maybe you want to check this page :
https://www.postgresql.org/docs/9.5/static/app-createuser.html
On Mon, Sep 4, 2017 at 2:11 PM, Ramesh <ramesh4f@gmail.com> wrote:
> HI all
>
> Im new to postgres.
>
> I tried to create user with the command createuser from outside the
> psql client. But got the below error.
>
> Based on tutorial, I could see the createuser <<username>> gets created,
> but while login it will throw error. My case is like below.
>
>
> [postgres@localhost ~]$ createuser mytest
> Password:
> createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
>
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: New to postgreSQL
@ 2017-09-04 16:08 tirveni yadav <yadav.tirveni@gmail.com>
parent: Ramesh <ramesh4f@gmail.com>
1 sibling, 1 reply; 10+ messages in thread
From: tirveni yadav @ 2017-09-04 16:08 UTC (permalink / raw)
To: Ramesh <ramesh4f@gmail.com>; +Cc: pgsql-admin
On Mon, Sep 4, 2017 at 7:41 PM, Ramesh <ramesh4f@gmail.com> wrote:
> HI all
>
> Im new to postgres.
>
> I tried to create user with the command createuser from outside the psql
> client. But got the below error.
>
> Based on tutorial, I could see the createuser <<username>> gets created, but
> while login it will throw error. My case is like below.
>
>
> [postgres@localhost ~]$ createuser mytest
> Password:
> createuser: could not connect to database postgres: FATAL: password
> authentication failed for user "postgres"
This could be due to enabling md5 authentication for user postgres.
And password not yet set up for the user postgres.
Check pg_hba.conf.
--
Regards,
Tirveni Yadav
www.udyansh.org
www.bael.io
What is this Universe ? From what it arises ? Into what does it go?
In freedom it arises, In freedom it rests and into freedom it melts away.
Upanishads.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: New to postgreSQL
@ 2017-09-04 16:40 Tom Lane <tgl@sss.pgh.pa.us>
parent: tirveni yadav <yadav.tirveni@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Tom Lane @ 2017-09-04 16:40 UTC (permalink / raw)
To: tirveni yadav <yadav.tirveni@gmail.com>; +Cc: Ramesh <ramesh4f@gmail.com>; pgsql-admin
tirveni yadav <yadav.tirveni@gmail.com> writes:
> On Mon, Sep 4, 2017 at 7:41 PM, Ramesh <ramesh4f@gmail.com> wrote:
>> [postgres@localhost ~]$ createuser mytest
>> Password:
>> createuser: could not connect to database postgres: FATAL: password
>> authentication failed for user "postgres"
> This could be due to enabling md5 authentication for user postgres.
> And password not yet set up for the user postgres.
On most Linux distros, the default setup is that the postgres database
user has no password --- if it did, everybody and his brother would try
that password first if they wanted to break into a database :-(.
Rather, it's typically set up so that if you are logged in as the
operating system's postgres user, as Ramesh seems to be, it will let
you in automatically based on peer authentication. So it's not clear
why that's not working. Looking at the pg_hba.conf file to see what
the actual authentication setup is would be a good thing.
One idea is that there's a PGHOST environment variable setting that
is affecting how createuser thinks it should connect. Peer auth
only works when you come in through a Unix socket.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: New to postgreSQL
@ 2017-09-04 16:52 Siva Kandasamy <sivajankan@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 10+ messages in thread
From: Siva Kandasamy @ 2017-09-04 16:52 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: tirveni yadav <yadav.tirveni@gmail.com>; Ramesh <ramesh4f@gmail.com>; pgsql-admin
Something wrong on making default connection to your server. I would
suggest try to connect default database as postgres user using psql; which
will let you know if there is connection problem. Once you resolved
'default' connection problem, 'createuser' will work fine.
For starters try 'psql -U postgres'.
More info: https://wiki.postgresql.org/wiki/First_steps
All the best!!
Siva
On Mon, Sep 4, 2017 at 12:40 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> tirveni yadav <yadav.tirveni@gmail.com> writes:
> > On Mon, Sep 4, 2017 at 7:41 PM, Ramesh <ramesh4f@gmail.com> wrote:
> >> [postgres@localhost ~]$ createuser mytest
> >> Password:
> >> createuser: could not connect to database postgres: FATAL: password
> >> authentication failed for user "postgres"
>
> > This could be due to enabling md5 authentication for user postgres.
> > And password not yet set up for the user postgres.
>
> On most Linux distros, the default setup is that the postgres database
> user has no password --- if it did, everybody and his brother would try
> that password first if they wanted to break into a database :-(.
> Rather, it's typically set up so that if you are logged in as the
> operating system's postgres user, as Ramesh seems to be, it will let
> you in automatically based on peer authentication. So it's not clear
> why that's not working. Looking at the pg_hba.conf file to see what
> the actual authentication setup is would be a good thing.
>
> One idea is that there's a PGHOST environment variable setting that
> is affecting how createuser thinks it should connect. Peer auth
> only works when you come in through a Unix socket.
>
> regards, tom lane
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
------------------------------------------
Sivakumar P Kandasamy
Software Engineer
Dartmouth College (dartmouth.edu)
------------------------------------------
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2017-09-04 16:52 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-01 19:39 New to PostgreSQL Mark Steben <msteben@autorevenue.com>
2006-11-02 07:44 ` Shoaib Mir <shoaibmir@gmail.com>
2006-11-03 19:40 ` Tomeh, Husam <htomeh@firstam.com>
2006-11-02 08:13 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2006-11-02 16:08 ` Andrew Sullivan <ajs@crankycanuck.ca>
2017-09-04 14:11 New to postgreSQL Ramesh <ramesh4f@gmail.com>
2017-09-04 14:28 ` Re: New to postgreSQL SEKA Bruno-Emmanuel <master.ematris@gmail.com>
2017-09-04 16:08 ` Re: New to postgreSQL tirveni yadav <yadav.tirveni@gmail.com>
2017-09-04 16:40 ` Re: New to postgreSQL Tom Lane <tgl@sss.pgh.pa.us>
2017-09-04 16:52 ` Re: New to postgreSQL Siva Kandasamy <sivajankan@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox