Re: [ADMIN] Specific questions about wraparound and vacuum

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

Re: [ADMIN] Fwd: resetting superuser password

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 your password: alter user

Re: [ADMIN] connection error

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 database

Re: [ADMIN] pgsql connection

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 I

Re: [ADMIN] backing up without lock ?

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,

Re: [ADMIN] unable to configure

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

Re: [ADMIN] replication for hot-standby?

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

Re: [ADMIN] restore database from bare files

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 tarball

Re: [ADMIN] restore database from bare files

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 Maybe you must reset the WAL's ( http://www.postgresql.org/docs/7.3/interactive/app-pgresetxlog.html

Re: [ADMIN] change existing table definition

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

Re: [ADMIN] change existing table definition

pg_dump -c -t table name database dumpfile psql database dumpfile 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

[ADMIN] DRDB?

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,