On Wed, Dec 15, 2004 at 04:14:48PM +0800, daxiawj wrote:
> After I Updatded my pgsql from 7.3 to 7.4.6 in debian with "aptitude", I
> found that my admin user account's password has gone--everytime when I
> login into psql, I don't need type my password any more, and every
> other user account to
On the bottom of this
page)http://www.varlena.com/varlena/GeneralBits/Tidbits/), there is a
script you can download called pgsession.
On Wed, 8 Dec 2004 17:07:56 +0200, Pascal Tufenkji <[EMAIL PROTECTED]> wrote:
> Hi,
> I'm using PostgreSQL 7.3.2
> Is there a way to know if there are users con
Hi all!
We are currently running a 7.3.4 backed and planning to upgrade.
However we can't do to much/at all changes in the applications using the db.
So the question is to what version to upgrade :
what is the best release from the 7.3.* ?
would the upgrade to 7.4.* require serious changes in the a
Hello all,
After I Updatded my pgsql from 7.3 to 7.4.6 in debian with "aptitude", I
found that my admin user account's password has gone--everytime when I
login into psql, I don't need type my password any more, and every
other user account too.
I know that a SQL command Alter could de used to al
I am going to be on leave from work for a few months and am trying to
remove myself from the admin and sql lists until I return. I received
the following message below. Can anyone assist? I am not sure why it's
not working.
My email address is [EMAIL PROTECTED] and my alias for this account is
Hi,
I would like my email address to be removed from all the postgres lists. I've tried to unsubscribe several times but it turned out unsuccessful. Could someone please help me?
Kind regards,
Helena Lourenco
On Wed, 2004-12-15 at 03:52, Tsirkin Evgeny wrote:
> Hi all!
> We are currently running a 7.3.4 backed and planning to upgrade.
> However we can't do to much/at all changes in the applications using the db.
> So the question is to what version to upgrade :
> what is the best release from the 7.3.*
On Wed, Dec 15, 2004 at 10:09:32AM -0600, Bruno Wolff III wrote:
>
> You would have to do a dump and reload to go to the 7.4 series.
...and the "If You Are Upgrading" section of the "Installation
Instructions" chapter in the documentation recommends using pg_dumpall
from the version you're upgrad
On Wed, Dec 15, 2004 at 08:42:17PM +0800, Wang Jun wrote:
> I have modified my pg_hda.conf as the DOC said, and I can login with my
> password use "psql" in terminal. But it still remains a problem that I
> can't acess to my database through webclients such as PhpPgAdmin and my
> other phpclient.
On Wed, Dec 15, 2004 at 10:20:00AM -0600, Scott Marlowe wrote:
> For upgrades from one major version to the next, you'll need to:
>
> -- pg_dump all databases in the cluster. (optionally, also backup the
> files in the $PGDATA directory)
[&c.]
Or
-- install Slony-I
-- replicate from 7.3.x -> 7
Jodi Kanter wrote:
I am going to be on leave from work for a few months and am trying to
remove myself from the admin and sql lists until I return. I received
the following message below. Can anyone assist? I am not sure why it's
not working.
My email address is [EMAIL PROTECTED] and my alias fo
Iain wrote:
Upon further investigation, I think this the way to go, specificaly
I'llbe recommending the 320-2 as I plan to put the WAL and DB on
seperate channels and partitions (as opposed to to putting them on the
same logical partition split over the two channels).
SOmething to think about. L
Iain wrote:
Hi William,
SOmething to think about. Let's suppose a channel/cable completely
dies. How would you protect against it? Split a logical mirror device
over 2 channels.
This effectively implements RAID 0+1, right? RAID 1 (mirroring) over
RAID 0 striped volumes. I can certainly see your
> > After I Updatded my pgsql from 7.3 to 7.4.6 in debian with
> "aptitude", I
> > found that my admin user account's password has gone--everytime when
> I
> > login into psql, I don't need type my password any more, and every
> > other user account too.
>
> Have you looked at pg_hba.conf? See
On Wed, Dec 15, 2004 at 11:52:35 +0200,
Tsirkin Evgeny <[EMAIL PROTECTED]> wrote:
> Hi all!
> We are currently running a 7.3.4 backed and planning to upgrade.
> However we can't do to much/at all changes in the applications using the db.
> So the question is to what version to upgrade :
> what is
2 bits of wisdom:
1. As mentioned below, always try this upgrade on a test/ offline/
sandbox/ development/ testing /etc server first
-- Clean out the $PGDATA directory (keep a copy of your pg_hba.conf and
postgresql.conf for reference)
2. A simple 'mv data/ data73/' after pg shutdown keeps your 7
Hi William,
SOmething to think about. Let's suppose a channel/cable completely dies.
How would you protect against it? Split a logical mirror device over 2
channels.
This effectively implements RAID 0+1, right? RAID 1 (mirroring) over RAID 0
striped volumes. I can certainly see your point regard
Hello,
I have a DB with about 30 tables, where 2 tables are significantly
larger than the rest, and contain a bit over 100,000 rows.
Every night I do these 3 things:
VACUUM;
ANALYZE;
pg_dump
I am noticing that the VACUUM part takes nearly 30 minutes, during
which the DB is not very accessible (a
18 matches
Mail list logo
