sorry for the typo, "debian and apt-get" On Mon, Jul 25, 2011 at 5:39 PM, Yan Chunlu <springrider@xxxxxxxxx> wrote: > I am using debian and apt-get to install postgresql, dpkg list shows > they are the same? is there anyway to tell what's version it is > compiled from? thanks! > > Master# dpkg -l |grep post > ii postgresql-9.0 9.0.4-1+b1 > object-relational SQL database, version 9.0 server > ii postgresql-client-9.0 9.0.4-1+b1 > front-end programs for PostgreSQL 9.0 > ii postgresql-client-common 118 > manager for multiple PostgreSQL client versions > ii postgresql-common 118 > PostgreSQL database-cluster manager > ii postgresql-contrib-9.0 9.0.4-1+b1 > additional facilities for PostgreSQL > ii postgresql-server-dev-9.0 9.0.4-1+b1 > development files for PostgreSQL 9.0 server-side programming > > > Slave $ dpkg -l |grep post > ii postgresql-9.0 9.0.4-1+b1 > object-relational SQL database, version 9.0 server > ii postgresql-client-9.0 9.0.4-1+b1 > front-end programs for PostgreSQL 9.0 > ii postgresql-client-common 118 > manager for multiple PostgreSQL client versions > ii postgresql-common 118 > PostgreSQL database-cluster manager > ii postgresql-contrib-9.0 9.0.4-1+b1 > additional facilities for PostgreSQL > > > > On Mon, Jul 25, 2011 at 3:38 PM, Fujii Masao <masao.fujii@xxxxxxxxx> wrote: >> On Mon, Jul 25, 2011 at 10:56 AM, Yan Chunlu <springrider@xxxxxxxxx> wrote: >>> I think the problem is still "invalid record length" and "invalid >>> magic number", it start showing right after I complete sync data and >>> start slave. If I stop slave later and restart, yes it could show >>> xlog not found and can not catch master. but why the "invalid" things >>> in the first place? >> >> You might have the same problem which was reported before. >> http://archives.postgresql.org/pgsql-hackers/2011-06/msg00661.php >> >> That problem was fixed, and the fix will be included in next minor >> update (i.e., 9.0.5). >> http://archives.postgresql.org/pgsql-committers/2011-06/msg00101.php >> >> Of course, you can avoid the problem by building PostgreSQL with >> gcc != 4.6.0, I think. >> >> Regards, >> >> -- >> Fujii Masao >> NIPPON TELEGRAPH AND TELEPHONE CORPORATION >> NTT Open Source Software Center >> > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general