[GENERAL] Fwd: postgresql redhat
-- Forwarded message -- From: Brahim SABIRI b.sab...@gmail.com Date: 2014-02-11 0:51 GMT+00:00 Subject: postgresql redhat To: pgsql-bog...@postgresql.org Hi During installation of installation of postgresql9.3.2 on red hat 5.5 64bits, I have the problem with C compiler : *configure: error: in '/root/postgresql-9.3.2':* *configure: error: C compiler cannot create executables* are thse versions are compliant ? Regards
Re: [GENERAL] Fwd: postgresql redhat
Hi, On Tue, 2014-02-11 at 21:07 +, Brahim SABIRI wrote: During installation of installation of postgresql9.3.2 on red hat 5.5 64bits, I have the problem with C compiler : *configure: error: in '/root/postgresql-9.3.2':* *configure: error: C compiler cannot create executables* are thse versions are compliant ? I think you are missing gcc-c++ package. Still, we have RPMs for RHEL 5 + PostgreSQL 9.3: http://yum.postgresql.org/9.3/redhat/rhel-5-x86_64/ Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[GENERAL] Can not upgrade from 9.1 to 9.2 or 9.3, --HELP
I went through postgres website since yesterday and can not upgrade my postgresql from 9.1 to anything greater. At first I did pgupgrade and was told to install postgres-xc, when I installed it, it removed 9.1 and I could not log into it. I was able to recover it and when I the steps from https://wiki.postgresql.org/wiki/Apt I get pgadmin3 : Depends: libwxbase2.8-0 (= 2.8.12.1+dfsg) but 2.8.12.1-14ubuntu1.1 is to be installed Depends: libwxgtk2.8-0 (= 2.8.12.1+dfsg) but 2.8.12.1-14ubuntu1.1 is to be installed. Do I just install libwxgtk2.8-0? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Can-not-upgrade-from-9-1-to-9-2-or-9-3-HELP-tp5791837.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL]
Hi During installation of installation of postgresql9.3.2 on red hat 5.5 64bits, I have the problem with C compiler : *configure: error: in '/root/postgresql-9.3.2':configure: error: C compiler cannot create executables* are these versions are compliant (red hat 5.5 64bits and postgresql9.3.2) ? Regards
Re: [GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'
Adarsh Sharma escribió: [cur:1835/26FAFEF8, xid:471303469, rmid:11(Btree), len/tot_len:18/5754, info:8, prev:1835/26FAFEB0] insert_leaf: s/d/r:1663/1228184/1363155 tid 28366/20 Is dere any document where i can co-relate this tid with relations/indexes in the database. I tried but not able to find :- wap_prod_adserve=# SELECT relname, oid FROM pg_class where oid=1363155 ; relname | oid -+- (0 rows) Probably the reason you don't find any rows is because you're querying the wrong column. The r stands for relfilenode, and thus you must use relfilenode in the WHERE clause, not oid: SELECT relname, oid FROM pg_class where relfilenode=1363155 ; -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Can not upgrade from 9.1 to 9.2 or 9.3, --HELP
bobspero wrote I went through postgres website since yesterday and can not upgrade my postgresql from 9.1 to anything greater. At first I did pgupgrade and was told to install postgres-xc, when I installed it, it removed 9.1 and I could not log into it. I was able to recover it and when I the steps from https://wiki.postgresql.org/wiki/Apt I get pgadmin3 : Depends: libwxbase2.8-0 (= 2.8.12.1+dfsg) but 2.8.12.1-14ubuntu1.1 is to be installed Depends: libwxgtk2.8-0 (= 2.8.12.1+dfsg) but 2.8.12.1-14ubuntu1.1 is to be installed. Do I just install libwxgtk2.8-0? Are you using the standard Debian PostgreSQL packages or are you using postgres-xc? If you are not using postgres-xc then the system telling you that you need it is unusual enough to stop then and ask questions - that you did not means you should be prepared to restore from backups. If you are using postgres-xc then they are the ones you need to talk with and using the standard base release packages is not going to help since they are different products. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Can-not-upgrade-from-9-1-to-9-2-or-9-3-HELP-tp5791837p5791860.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Can not upgrade from 9.1 to 9.2 or 9.3, --HELP
On 02/13/2014 04:57 AM, bobspero wrote: I went through postgres website since yesterday and can not upgrade my postgresql from 9.1 to anything greater. At first I did pgupgrade and was told to install postgres-xc, when I installed it, it removed 9.1 and I could not log into it. What/who told you to install postgres-xc? I was able to recover it and when I the steps from https://wiki.postgresql.org/wiki/Apt I get pgadmin3 : Depends: libwxbase2.8-0 (= 2.8.12.1+dfsg) but 2.8.12.1-14ubuntu1.1 is to be installed Depends: libwxgtk2.8-0 (= 2.8.12.1+dfsg) but 2.8.12.1-14ubuntu1.1 is to be installed. Do I just install libwxgtk2.8-0? So I am guessing you are running Ubuntu, correct? What version are you on? You added the Postgres apt repositories and are trying to install from there? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Can-not-upgrade-from-9-1-to-9-2-or-9-3-HELP-tp5791837.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Restore postgresql data directory to tablespace on new host? Or swap tablespaces?
I have a bunch of test/development databases which we currently refresh with production data as-needed using a NetApp filer's snapshot capabilities - we have a production slave with its datadir on a filer mount (NFS), and once a night (via cron) we shutdown the slave, snapshot the filer volume, and then start the database back up. When we need to do data refresh in a test/dev environment, we stop postgres there, clone the NetApp snapshot, and use that clone as the test/dev environment data directory. This is wonderful from a storage point of view, as the clones only store changed blocks on the filer. We have a ~1.5TB datadir, but these clones are only a few MB each, because there's little changed data. (We're running postgres 9.0.13, but if what I'm about to ask is more possible with a newer version, that's a vague possibility) Up until now, each test/dev environment has had its own postgres server. That's pretty bad on resources, since they're largely idle most of the time. Now, we have to spin up somewhere around 100-150 of these environments. The NetApp is about the only way we can do it, because we simply don't have 150-225TB of disk to spare. It would also be a real pain (and inefficient) to run 100-150 separate machines, each running a single instance of postgres. What I'd like to do is take a disk/filer snapshot of a stopped database (i.e. the actual files on disk, not a pg_dump) on one postgres instance (one physical server) and restore it on a different one. Ideally the database would have a different name, but that's flexible. Even more ideally this would all happen without a restart of the destination postgres instance, but I suppose we can work around that too. Is this even possible? Anyone have experience with, essentially, creating a tablespace that points to an existing data directory? Or, alternatively, swapping out the data directory of one tablespace with that of another? Any advice or suggestions would be greatly appreciated. I apologize if there's something obvious in the documentation that I missed, but I'm not much of a database guru, and am relatively new to pgsql in general. Jason Antman PS - The slightly-less-abstract explanation: We're spinning up nearly 100 (maybe 150) new test environments. We simply don't have the ~200T of disk to maintain a separate DB for each of them, so using the NetApp filer and letting it do thin clones is an absolute requirement. We also need to be able to do quick restores to the latest daily production snapshot. Quick as in, the developers and testers run a script in their test environment that does the restore. We're currently doing this for ~50 environments, and we run a separate VM with postgres for each one, so it's relatively straightforward - stop postgres, unmount the datadir, do the filer magic to refresh it with a clone of this morning's production DB, then re-mount the new filer volume (clone) and start postgres. Unfortunately, the massive overhead of running a separate virtual machine with a separate postgres instance for every DB is more than we can handle when scaling 2-3x. In addition to that, the resource waste is awful (a dedicated VM running a dedicated postgres instance for each DB, most of which are idle about 14 hours/day). So, we'd like to run multiple databases in separate tablespaces, but on the same host and the same postgres instance, so N databases can use the same shared memory, etc. The developers and testers who use these instances need to be able to get fresh data as often as need (sometimes 3x/day). Ideally we'd be able to refresh one of these filer volumes without stopping postgres. But it's also an acceptable alternative to build out, say, 3x the number of DBs we need, and refresh all of the not-currently-in-use ones on a schedule every night, during a maintenance/downtime window.
Re: [GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'
Yes. Able to retrieve table names now. I am reviewing the xlogdump output. Is dere any way where i can understand what is the meaning of these keywords in it. [root@1002 tmp]# xlogdump pg_xlog/* fullanalysis.txt [root@1002 tmp]# cat fullanaysis.txt | awk '{print $7}' | sort | uniq XLP_BKP_REMOVABLE bkpblock[1]: bkpblock[2]: commit_compact create delete: heap2_multi_insert: hot_update: inplace: insert_leaf: insert_upper: newpage: newroot: offset reuse_page: seq split_l: split_l_root: split_r: split_r_root: standby update(init): update: Thanks
Re: [GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'
On Fri, Feb 14, 2014 at 3:14 PM, Adarsh Sharma eddy.ada...@gmail.com wrote: Yes. Able to retrieve table names now. I am reviewing the xlogdump output. Is dere any way where i can understand what is the meaning of these keywords in it. [root@1002 tmp]# xlogdump pg_xlog/* fullanalysis.txt [root@1002 tmp]# cat fullanaysis.txt | awk '{print $7}' | sort | uniq XLP_BKP_REMOVABLE bkpblock[1]: bkpblock[2]: commit_compact create delete: heap2_multi_insert: hot_update: inplace: insert_leaf: insert_upper: newpage: newroot: offset reuse_page: seq split_l: split_l_root: split_r: split_r_root: standby update(init): update: Even if it is easy to guess to which WAL operations all those terms refer to, referring to the source code is easier IMO: https://github.com/snaga/xlogdump/blob/master/xlogdump_rmgr.c Regards, -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general