Have you read
http://www.postgresql.org/docs/8.2/static/tutorial.html
??
If there are specific parts in there that are unclear or missing I'm
sure the developers would be happy to know.
-Doug
---(end of broadcast)---
TIP 9: In versions below 8.0,
There are a couple of PostgreSQL tutorials around the web. I have
followed them. Downloaded the *.rpm files and installed them. Then gone
into my WHM (https://myserver:2087) and enabled the config, and set up
the postgres user with an "su" command "adduser postgres".
Now what?
1. Where's the inte
# [EMAIL PROTECTED] / 2007-01-23 23:17:31 +0800:
> >Please don't top-post, it disturbes the flow of the communication.
>
> Interesting. I prefer getting to the point an author is making.
Top posting means you end up far off the mark.
> >There's documentation about that too, at the end of the in
On Wed, Jan 24, 2007 at 02:17:53 +0800,
Erick Papadakis <[EMAIL PROTECTED]> wrote:
>
> I was just looking at the ident/trust/etc authentication banter from
> pgsql docs. Couldn't make out what greek was on there. When I jostled
> a bit, and finally understood it, and really wanted to write it in
On Wed, Jan 24, 2007 at 02:17:53AM +0800, Erick Papadakis wrote:
> Cpanel team takes care of all of this. All it takes is for someone
> like pgsql to wake up, smell the coffee, and get over the ignorance
> about a platform that is the most prevalent in the web hosting world.
> Cpanel is used by mil
Erick Papadakis wrote:
Right now, if I wish to contribute to the documentation, how do I make
it relevant? Look at MySQL docs, or PHP manual. I can leave comments
in a context-relevant manner -- e.g., check at the bottom of page:
http://sg.php.net/manual/en/ref.pgsql.php.
Have you seen the "int
How about using "updatedb" before using whereis or locate?
Regards, Frank.
On Wed, 24 Jan 2007 01:18:20 +0800 "Erick Papadakis" <[EMAIL PROTECTED]>
thought long, then sat down and wrote:
> Where is pg_hba.conf?
>
> I tried find and whereis commands, but could not find it.
>
> Thanks for any
I use PostgreSQL now since about 10 years, a long time on SuSE-Linux, since
about 2 years on CentOS, also on RedHat, NetBSD and Solaris, and I never had
any problems with installation or initialization or documentation.
Simply follow the few steps at the beginning of the INSTALL file included wi
Martijn van Oosterhout wrote:
> On Wed, Jan 24, 2007 at 01:31:23AM +0800, Erick Papadakis wrote:
>> I am not speaking of exotic platforms like some obscure fork of POSIX
>> or something. I am speaking of Cpanel/WHM with Linux (CentOS in my
>> case) which must be hosted on hundreds of thousands of w
I think it's some sort of serum they inject into semi-skilled i.t.
workers that makes them arrogant and spout off random poorly
constructed off topic posts on professional mailing lists while asking
for help in the same breath. Fortunately, I never went to college and
missed my shot.
You clear
Setting aside the fact that I don't even know what Cpanel is, I'm not
sure how this is practical. How many versions of Cpanel are there and
which versions of postgres do they ship? If Cpanel releases a new
version, do the postgresql docs needs to be updated?
Cpanel team takes care of all of thi
On 1/23/07, Martijn van Oosterhout wrote:
On Wed, Jan 24, 2007 at 01:31:23AM +0800, Erick Papadakis wrote:
> I am not speaking of exotic platforms like some obscure fork of POSIX
> or something. I am speaking of Cpanel/WHM with Linux (CentOS in my
> case) which must be hosted on hundreds of thou
On Wed, Jan 24, 2007 at 01:31:23AM +0800, Erick Papadakis wrote:
> I am not speaking of exotic platforms like some obscure fork of POSIX
> or something. I am speaking of Cpanel/WHM with Linux (CentOS in my
> case) which must be hosted on hundreds of thousands of webservers
> around the world.
Sett
Erick Papadakis schrieb:
Correct. Also you will find nearly no stuff about using apt-get and rpm,
which are some of the most used package systems on Linux on
postgresql.org .
And nothing about emerge, which is central to Gentoo Linux. And no real
documentation to ports, which is prevalent on Fr
Correct. Also you will find nearly no stuff about using apt-get and rpm,
which are some of the most used package systems on Linux on postgresql.org .
And nothing about emerge, which is central to Gentoo Linux. And no real
documentation to ports, which is prevalent on FreeBsd.
PostgreSQL.org has e
pg_hba.conf is within the PostgreSQL data directory.
That directory can be put everywhere by the installation routine.
usual places:
- on windows per default below \programme\postgresql\8.2\data
- within linux often below /var
I tried find and whereis commands, but could not find it.
Either
Where is pg_hba.conf?
I tried find and whereis commands, but could not find it.
Thanks for any pointers.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining colum
On 1/23/07, Erick Papadakis <[EMAIL PROTECTED]> wrote:
Doesn't work:
- psql -U postgres
> psql: FATAL: Ident authentication failed for user "postgres"
- psql -U postgres -W
> psql: FATAL: Ident authentication failed for user "postgres"
that is saying you need to have the password to log
Erick,
- psql -U postgres
> psql: FATAL: Ident authentication failed for user "postgres"
Nice. This gives us some more information about what kind of client
authorization is configured by cpanel.
You can read everything about client-autorisation on:
http://www.postgresql.org/docs/8.2/inte
"Erick Papadakis" <[EMAIL PROTECTED]> writes:
> Doesn't work:
> - psql -U postgres
psql: FATAL: Ident authentication failed for user "postgres"
su to postgres, then psql will let you in. Or you can RTFM about
changing the default authentication method ...
regards, t
Erick Papadakis schrieb:
Doesn't work:
- psql -U postgres
> psql: FATAL: Ident authentication failed for user "postgres"
- psql -U postgres -W
> psql: FATAL: Ident authentication failed for user "postgres"
Would appreciate some insights. Where's the step by step guide to make
this work? C
Please don't top-post, it disturbes the flow of the communication.
Interesting. I prefer getting to the point an author is making.
There's documentation about that too, at the end of the installation
instructions IIRC.
I did not see them. Please point me? I'd deeply appreciate it.
This
Doesn't work:
- psql -U postgres
> psql: FATAL: Ident authentication failed for user "postgres"
- psql -U postgres -W
> psql: FATAL: Ident authentication failed for user "postgres"
Would appreciate some insights. Where's the step by step guide to make
this work? Cpanel/WHM and Plesk are TH
Erick Papadakis wrote:
> Thanks Thomas.
Please don't top-post, it disturbes the flow of the communication.
> But:
>
> - "psql" at the command says
> > psql: FATAL: database "root" does not exist
>
> - "psql -d postgres" at the command says
> > psql: FATAL: role "root" does not exist
>
> Ho
Erick,
psql -U postgres
should help.
I hope you remembered the password you gave to the database superuser while
installing...
best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Python:
Thanks Thomas.
But:
- "psql" at the command says
> psql: FATAL: database "root" does not exist
- "psql -d postgres" at the command says
> psql: FATAL: role "root" does not exist
How should I create the first database, or the first user etc? The
links you suggested are all *after* I login t
On 23.01.2007 15:10 [EMAIL PROTECTED] wrote:
Now what?
1. Where's the interactive shell?
http://www.postgresql.org/docs/8.2/static/app-psql.html
> How can I start creating a database,
http://www.postgresql.org/docs/8.2/static/app-createdb.html
creating users, testing things out?
http://ww
There are a couple of PostgreSQL tutorials around the web to make it
work with WHM.
I have followed them. Downloaded the *.rpm files and installed them.
Then gone
into my WHM (https://myserver:2087) and enabled the config, and set up
the postgres user with an "su" command "adduser postgres".
Now
28 matches
Mail list logo
