[ADMIN] pgstat wait timeout
Hi everyone. I have been installed postgresql 9.0.2 on a windows 2008 x64 server. The postgres is running, without any application accessing the server. In the log appear : WARNING: pgstat wait timeout This error appear constantly and some times when I do a query, very simple query like create table, I get a timeout from postgres and in the log appear several times: WARNING: no hay una transacción en curso (in english that means no transaction in progress) Any ideas?
[ADMIN] Postgre installation Windows
Dear All: Is there a guide/how to for Postgre 9.0.2 installation/Configuration on a windows servers (2003 and above) Thanks
Re: [ADMIN] Postgre installation Windows
Is there a guide/how to for Postgre 9.0.2 installation/Configuration on a windows servers (2003 and above) Have you tried searching? A well known search engine finds about 3,840,000 results for postgres install windows. Or try http://www.postgresql.org/docs/9.0/static/index.html -- Ian. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Postgre installation Windows
Ammar Fallaha ammar.fall...@automata4.com wrote: Is there a guide/how to for Postgre 9.0.2 installation/ Configuration on a windows servers (2003 and above) In addition to the fine manual, there is a Wiki with some pages which may help. In particular: http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows http://wiki.postgresql.org/wiki/Troubleshooting_Installation http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] size of the database
Database PostgreSQL 8.1.22 takes 2 GB. I deleted a table of 300 MB. But the database still takes up 2 GB. I deleted the indexes of 200 MB but the base still has 2 GB. What should I do? Thank you, Muljevski Zoran
Re: [ADMIN] Data duplication when moving datafiles from one server to another.
IñigoMartinez Lasala imarti...@vectorsf.com wrote: Data duplication happened on source server (that is, on production environment). This data duplication affected only on some tables, with some duplicated PKs and altered sequences (sequences value didn't match select max() and we had to fix it manually). We rsync from production servers all the time, and have never seen such problems. Maybe someone else has ideas beyond my long shots (below). Postgres version is 8.2.7 64bit on Ubuntu Server 8.04 LTS There have been 12 bug fix releases for the 8.2 major release since 8.2.7. It's not impossible that you somehow hit a bug which has been fixed in the last 33 months. http://www.postgresql.org/support/versioning http://www.postgresql.org/docs/8.2/static/release.html Rsync command was: rsync -avt -lHpogDtx /srv/postgresql/8.2/main/ r...@destination_server:/srv/postgresql/8.2/main/ Did it run successfully on the first try, or might there have been an attempt where the target was mis-specified? A space instead of a colon between the target server and path might have caused the kind of corruption you're seeing. Also -- I would avoid using root for such things. We have remote root login disabled entirely on our machines, and limit the use of that login to situations where there is no reasonable alternative. and was launched from source server. I find it's harder to accidentally damage the remote copy, so I run rsync from the target where possible. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] size of the database
Zoran muljevski muljev...@gmail.com wrote: Database PostgreSQL 8.1.22 takes 2 GB. I deleted a table of 300 MB. But the database still takes up 2 GB. I deleted the indexes of 200 MB but the base still has 2 GB. What should I do? What is your OS? How are you measuring this? -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] pg_clog not getting cleared
Hello. I posted this once before, but I'm encountering it again. Each Saturday, I run: vacuumdb -a -v. I have autovac on all the time. However, my pg_clog directory lists clog files going back to July. This is pg 8.4.4 on Linux (CentOS 5.5). I know this isn't a whole lot of information at this time. What more would be useful in finding out what's failing and where? I seem to recall that doing vacuumdb -f -a -v resolved it, which would seem to point to a database not being vacuumed, but that's sort of the point of the -a switch, right? I'm running this as the postgres user himself.
Re: [ADMIN] pg_clog not getting cleared
Scott Whitney sc...@journyx.com wrote: Each Saturday, I run: vacuumdb -a -v. I have autovac on all the time. However, my pg_clog directory lists clog files going back to July. This is pg 8.4.4 on Linux (CentOS 5.5). I know this isn't a whole lot of information at this time. What more would be useful in finding out what's failing and where? Nothing is failing -- clog is needed to track what has committed until transactions are frozen. I seem to recall that doing vacuumdb -f -a -v resolved it Are you sure that wasn't -F rather than -f ? The uppercase switch freezes tuples, which would allow clog to be cleaned up. This shouldn't normally be needed, unless you have some other reason to need aggressive freezing. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] how made procedure returned different types of value?
In postgres im beginer .How write procedure returned different types of value?i need function to select different data types from table columns and returned.i try overload name of function but its bad idea.it is possible? anybody?
[ADMIN] Problems Upgrading from 8.2 to 9.0
Hi, I have a very old postgres 8.2 server which I want to upgrade to 9.0.2 server, the server are on different boxes and the 9.0.2 is fully running. I think that my 8.2 contains tsreach2 which none of my applications use. The postgres 8.2 is running on Windows 2003 server and 9.0.2 is running on Windows 2008 R2 server. I used pg_dumpall --username=postgres backup.dump on the 8.2 server using 9.0 binaries for pg_dumpall on the 9.0 server I tried psql --username=postgres backup.dump and i got tons of errors a small sample is below. I have no idea what these errors mean or to get around them, any advice would be appreciated. pg_dumpall dumps CREATE DDL for the postgres user but when I connect to psql to restore it tries to create the postgres user which already exists how can I tell pg_dumpall to ignore dumping the definition of postgres account it already exists on the target database. I read through the docs on pg_dumpall but could not find a command line to do this. ERROR: type tsvector is only a shell ERROR: type tsvector is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsvector is only a shell ERROR: type tsvector is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsvector is only a shell ERROR: type tsvector is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsvector is only a shell ERROR: type tsvector is only a shell ERROR: type tsvector is only a shell ERROR: type tsvector is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsquery is only a shell ERROR: type tsvector is only a shell ERROR: operator class gin_tsvector_ops does not exist for access method gin ERROR: type tsquery is only a shell ERROR: operator class gist_tp_tsquery_ops does not exist for access method ERROR: type tsvector is only a shell ERROR: operator class gist_tsvector_ops does not exist for access method gi ERROR: type tsquery is only a shell ERROR: operator class tsquery_ops does not exist for access method btree ERROR: type tsvector is only a shell ERROR: operator class tsvector_ops does not exist for access method btree ERROR: function dex_init(internal) does not exist CONTEXT: COPY pg_ts_dict, line 1, column dict_init: dex_init(internal) ERROR: function prsd_getlexeme(internal,internal,internal) does not exist CONTEXT: COPY pg_ts_parser, line 1, column prs_nexttoken: prsd_getlexeme(internal,internal,internal)
Re: [ADMIN] Problems Upgrading from 8.2 to 9.0
On Tue, 2010-12-21 at 22:39 -0800, Adib wrote: ERROR: type tsvector is only a shell ERROR: operator class gin_tsvector_ops does not exist for access method gin *IIRC*, you need to load contrib/tsearch2.sql to database *before* restoring your backup. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [ADMIN] Problems Upgrading from 8.2 to 9.0
Is there some way to avoid restoring tsearch2 since full text searching is now part of postgres 9.0, the apps that use the database don't do any full text searching. 2010/12/21 Devrim GÜNDÜZ dev...@gunduz.org On Tue, 2010-12-21 at 22:39 -0800, Adib wrote: ERROR: type tsvector is only a shell ERROR: operator class gin_tsvector_ops does not exist for access method gin *IIRC*, you need to load contrib/tsearch2.sql to database *before* restoring your backup. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz