Hi,
I have owned a server for about a year, and apparently PostgreSQL 7.2 was
originally installed with Redhat. I made an attempt to set up a database on
the current Postgres setup, but when trying to set up my configure files in
WHM (Cpanel) I received the error:
Setting up Postgres Config...Do
PROTECTED]
Sent: Tuesday, February 10, 2004 5:50 PM
To: Jeremy Smith
Subject: RE: [ADMIN] Upgrading from 7.2 to 7.4.1 on Redhat 7
On Tue, 10 Feb 2004, Jeremy Smith wrote:
> Hello,
>
> thank you for this link. But I wonder, do I need to do this if postgres
has
> never actually been
PROTECTED] Behalf Of scott.marlowe
Sent: Tuesday, February 10, 2004 7:15 PM
To: Jeremy Smith
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Upgrading from 7.2 to 7.4.1 on Redhat 7
You're welcome. Glad it all worked for you. If it's any consolation,
that's probably the hardest stuff you
Hi again,
I have started working on migrating my DBs from mysql to postgres today and
ran into a problem. When I type in psql, I get this error:
Welcome to psql 7.3.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? fo
with file from package postgresql-libs-7.3.3-1PGDG
.
.
.
Jeremy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeremy Smith
Sent: Wednesday, February 11, 2004 11:44 AM
To: [EMAIL PROTECTED]
Subject: [ADMIN] psql not starting up..
Hi again,
I have started
esday, February 11, 2004 4:29 PM
To: [EMAIL PROTECTED]; scott.marlowe
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Upgrading from 7.2 to 7.4.1 on Redhat 7
On Tuesday 10 February 2004 07:37 pm, Jeremy Smith wrote:
> I actually had to install version 7.4.0 as there weren't any RPMs for
7.4.1
> on R
CTED]
Sent: Thursday, February 12, 2004 9:55 AM
To: Jeremy Smith
Cc: Lamar Owen; [EMAIL PROTECTED]
Subject: Re: [ADMIN] Upgrading from 7.2 to 7.4.1 on Redhat 7
On Wed, 11 Feb 2004, Jeremy Smith wrote:
> Thanks Lamar
>
> I will try that link later, for some reason it's not coming up now. I
Hi,
my php is not set up for postgres yet. When I try to install it using Build
Apache, I get an error that file "libpq-fe.h" is not found. Does anyone
know where to get this file and where it should be placed?
Thanks,
Jeremy
---(end of broadcast)--
It is a third party utility that installs it by RPMs. It should work the
same way as if I were installing the RPMs command line.
Jeremy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of scott.marlowe
Sent: Friday, February 13, 2004 3:39 PM
To: Jeremy Smith
I know this isn't strictly a postgresql question, but I'm sure it applies to
others out there using psql. If I am working in psql from SSH and switch to
another window, it seems that there is a very short window of time before
the window freezes and doesn't allow any more input. Does anyone know
and not postgres - i have 2 servers with the
same config but on diff networks - one neither have a freeze while
the other all the time.
Evgeny
On Sun, 15 Feb 2004 11:56:16 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Jeremy Smith" <[EMAIL PROTECTED]> writes:
>> I know
Just as a proof that this
is an ssh problem and not postgres - i have 2 servers with the
same config but on diff networks - one neither have a freeze while
the other all the time.
Evgeny
On Sun, 15 Feb 2004 11:56:16 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Jeremy Smith" <[
This may be an all-time idiotic question, but when I used phpmysql, when I
would type in a "DELETE FROM" query in the SQL window, it would make me
confirm it before I allowed it to go through. I don't think in all of the
presumably thousands of times that I used it that I ever canceled out of the
I have newly installed PostgreSQL onto my server, the server's main function
is to serve up a fantasy football site that has a tremendous number of
queries per page. Right now with very low traffic I am seeing a server load
of 2.0+. That got me a little concerned, so I looked at "top" and notice
EMAIL PROTECTED] Behalf Of Mitch Pirtle
Sent: Friday, February 20, 2004 1:57 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] PosgreSQL hogging resources?
Jeremy Smith wrote:
>I have newly installed PostgreSQL onto my server, the server's main
function
>is to serve up a
Great point Bruce,
I hadn't really thought of the semi-colon as a safety mechanism, but I guess
it is.
Jeremy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bruce Momjian
Sent: Friday, February 20, 2004 1:27 PM
To: Yuji Shinozaki
Cc: Dave Ewart; [EMAIL PRO
Jeremy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of scott.marlowe
Sent: Tuesday, February 10, 2004 11:43 AM
To: Jeremy Smith
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Upgrading from 7.2 to 7.4.1 on Redhat 7
Hi Jeremy. Updating major versions (i.e. 7
ROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] PosgreSQL hogging resources?
Jeremy Smith wrote:
>I will look into some of the suggestions you have made, the problem is that
>I can't do large scale optimization at the moment because I am still adding
>features to the site.
18 matches
Mail list logo
