Moving the -admin, please don't reply to -hackers on this.
On Fri, 2004-07-30 at 00:04, Coloring Graph wrote:
> I am has some trouble when connect to 7.5 devel PostgreSQL server,
> see belows
>
> my setup:
> ===
> os=Windows2000
> server version=the non-MSI snapshot at
> htt
Hello All
I have an account in our cluster. This is a normal linux use.
Our administrator have set up postgres there. But he have nt start up the postgreSQL server in the cluster.
Can anyone tell me how can I start up the postmaster and from an user space. Where should i need to configure
Hi,
Yesterday I ahve posted a message indicating that I had a problem the
following problem:
ERROR: could not access status of transaction 3145728
DETAIL: could not open file "/var/lib/pgsql/datos/pg_clog/0003": No such
file or directory
I know that the file /var/lib/pgsql/datos/pg_clog/0003
Hi,
Sorry to bother but what means whe the following error appears
ERROR: could not access status of transaction 3145728
DETAIL: could not open file "/var/lib/pgsql/datos/pg_clog/0003": No such
file or directory
I know that the file /var/lib/pgsql/datos/pg_clog/0003 doesn't exist but I
restart
Negyesi Karoly wrote:
Welcome,
I am planning to do a linux-ha cluster. Is replication applicable in a
solution like this? The main questions are that after the main node
fails and the slave node becomes the master:
-- a postmaster, started as slave, will be able to work standalone?
-- after repairi
Colin Stagner <[EMAIL PROTECTED]> writes:
> At random intervals that seem to vary by database uptime and usage, a
> COPY [table] FROM [file] statement involving maybe 20k - 80k rows
> (larger amounts of data than I usually work with, but nothing the
> server shouldn't be able to handle) will cra
Gaetano,
Thanks for your reply.
Gaetano Mendola wrote:
Are you performing queries using the like operator? If yes did you define
an index on it using the right operator class ?
Yes I do use the like operator to perform queries on a few 'varchar' and
'text' fields. I have indexed almost every colum
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am having some backend stability problems with postgresql 7.4.3 on
MacOS 10.3.4 ($OSTYPE=darwin7.0). I compiled 7.4.3 from the source less
than two weeks ago.
At random intervals that seem to vary by database uptime and usage, a
COPY [table] FROM
Another thought -
We had a similar issue recently. Our support guys dropped the database and
then rebuilt it from a dump file. The size of the data directory went down
from 12GB to less than 2GB. According to the sys ad that did the work
postgres is not very good a reclaiming disk space
Hi,
I don't want to offense you asking if you run vacuum full regullary. I
suppose that the 10Gb are plain of usefull data, aren't they ?
Luc
- Original Message -
From: "Steve" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 23, 2004 8:10 AM
Subject: [ADMIN] please please
Steve,
Are the three SCSI drives raided? If so, I would move the operating
database to that machine. From what I understand it can be a real
hassle to setup/maintain sym-linked tables. If you don't have the option
to move the database, I would explore one of these two routes:
Route one
Steve,
I'm not as much of an expert on PostgreSQL as others, but at least I
have SOME answer.
The way to leverage the multi-disk capability is to use RAID, either
software or hardware, rather than trying to twist the PostgreSQL
structure and files to do so.
RAID (I forget what the acronym stan
Steve,
I'm a little short on PostgreSQL experience, but gaining fast. I'm more of an
Oracle nut. But I think you've pin pointed the problem, namely disk contention. The
easiest solution I can think of would be to stripe the volume group across all three
drives thereby spreading the p
Hi there,
Can someone estimate disk space nescessary for PK creation on 70 mln records table?
table:
create table some_table (
col_one char(10) not null,
col_two smallint not null,
col_three bool not nul default false
);
PK should be created on "col_one" column.
Also, how much time it ca
Welcome,
I am planning to do a linux-ha cluster. Is replication applicable in a
solution like this? The main questions are that after the main node
fails and the slave node becomes the master:
-- a postmaster, started as slave, will be able to work standalone?
-- after repairing the main node, it
Hi,
I've asked this question a couple of times before on this forum but no
one seems to be nice enough to point me to the right direction or help
me out with any information, if possible. Please help me out with this
because this is a very serious issue for me and I need to learn more
about thi
Hello Folks,
Don't know whether this is the right group to post the question, but at
installing an application that uses Postgres, I get the following message:
ERROR: Load of file /usr/lib/pgsql/plpgsql.so failed:
/usr/lib/pgsql/plpgsql.so: undefined symbol: xlateSqlType
The calling command is:
17 matches
Mail list logo
