Hi,
thanks alot for your answers.
Yesterday I have updated the kernel. After a reboot, the ECC-Kernel error still
appears. Then I've cleaned
the RAM-Slots with nose-paper :), rebooted the machine, and the error was away!
Unbelievable, the error
was before on both the machines.
Yesterday nig
Hi,
i've a problem with my postgresql database (v8.1.5-13 on opensuse 10.2). The
database transaction
limit is running over and postgres does a restart.
I do daily a "vacuum verbose analyze" over the hole database. So what I'm doing
wrong? The db has
restarted itself to prevent a transaction-ov
Hi,
which version of postgres do you have? Put this temporarly into the /var/lib/pgsql/data/pg_hba.conf:
if postgres 8:
local all postgres 127.0.0.1/32 trust
if postgres 7:
local all trust
then connect to template1...:
psql -U postgres -d template1
...and set yo
Hi,
what does "iptables -L" and "/var/log/postgresql" say? Is there a packetfilter? The socket sems to be ok.
Can you telnet to the the socket?
Regards,
Martin
Am Mittwoch, den 21.09.2005, 16:08 +0800 schrieb Nirav Parikh:
Hi Martin,
Thanks for prompt reply. As I said before
Hi,
check "port = 5432" in postgresql.conf and have look to "netstat -anp | grep postmaster"...
Best regards,
Martin
Am Mittwoch, den 21.09.2005, 15:30 +0800 schrieb Nirav Parikh:
Hi,
I build the new server running FC4. I am having problem connecting to Postgresql data
Hi,
do you need an fs-backup or only dumps? You can Backup with Dumps and
archived WAL's by using pg_dump + pg_start/stop_backuo().
If you need a fs-backup, maybe xfs_freeze with syncing the
complete database (including WAL's) is a solution.
Best regards,
Martin
Am Montag, den 18.07.2005, 13
Hi,
configure it as root...
Best regards,
Martin
Am Montag, den 18.07.2005, 12:33 -0500 schrieb Mogin Mohandas:
> Hey,
> I have the postgresql source downloaded onto a linux cluster.
> But when I run ./configure along with its options it says permission
> Denied. Is it a previlage prob
Hi,
maybe filesystem-snapshots with wal's are your solution. There
is a block-device replication-tool too. It's called drbd
(http://www.drbd.org). I never tested/used it, but i heard it
should be fine.
I'm using rsync/xfs_freeze to make incremental filesystem-snapshots
(incremental by hardlinks)
ata/base/16980/
> so I made the assumption that 1 is a database (probably the test initial
> database ?), 16975 is an other one and 16980 a tird one ! How can I find
> the map from these numbers to database name ?
> thanks
> Martin Fandel wrote:
>
> >Hi
> >
> &
Hi
Maybe you must reset the WAL's
( http://www.postgresql.org/docs/7.3/interactive/app-pgresetxlog.html )
after restoring from tarball if postgres doesn't start.
Am Donnerstag, den 30.06.2005, 07:34 +0200 schrieb jehan:
> So I must one way or another run a 7.3, restore the file from the
> tarbal
> pg_dump -c -t >
> psql <
I don't tested this but i think this works.
Be dangerous with the "-c" Option of dump ;). After
the dump was created, new data could be inserted into the
database. If you dump in the file, all dumped tables are
dropped. It's better to RENAME the existing table and
Hi
ALTER TABLE is only in PostgreSQL 8. But you can create a new table
with varchar(50) and copy the data from the existing into the new
table. How much relation_size has your table? Do you create the
dbsize-functions which are included in the contrib package?
Best regards,
Martin
Am Dienstag,
and insert the different data (which is in the oldtable) into the
production table.
Greetings,
Martin
Am Dienstag, den 28.06.2005, 17:29 +0200 schrieb Martin Fandel:
> Hi
>
> ALTER TABLE is only in PostgreSQL 8. But you can create a new table
> with varchar(50) and copy the data fro
Hi all,
is DRDB (http://www.drbd.org/) a recommended replication-solution for
PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
Linux-Tag in germany. But I'm not very assured about this solution.
Which is the best solution? (Slony, DRDB, WAL or something else?)
Best regards,
Mar
14 matches
Mail list logo
