Re: [GENERAL] smtp

Hi, On Sun, 2007-07-15 at 09:49 +0100, paddy carroll wrote: Can I have a straw poll on the best way to glue smtp to postgres, is exim the only option? Postfix is another strong option (I haven't heard exim-postgres before, btw) Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting

Re: [GENERAL] CentOS 4 RPMs for 8.2.4?

8.2 srpm, will test and publish it until weekend. Keep eye on Planet PostgreSQL -- I will blog after I push the packages to FTP repos. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP

Re: [GENERAL] Suse RPM's

promised to build SuSE RPMs some time ago; however Reinhard said that they will keep the packages up2date. Reinhard, if SuSE is busy and/or is not willing to keep the packages updated, I can also build SuSE RPMs for the community... Kind regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting

Re: [GENERAL] PostgreSQL clustering (shared disk)

corrupted. Keep all the $PGDATA in the shared disk. That would minimize data loss (Of course, there is still a risk of data loss -- the postmasters are not aware of each other and they don't share each other's buffers, etc.) Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom

Re: [GENERAL] PostgreSQL clustering (shared disk)

Hi, On Thu, 2007-08-16 at 10:05 +0300, Devrim GÜNDÜZ wrote: (Of course, there is still a risk of data loss -- the postmasters are not aware of each other and they don't share each other's buffers, etc.) Err... I was talking about uncommitted transactions, and of course this does not mean

Re: [GENERAL] date of next Version 8.2 release

Hi, On Thu, 2007-08-30 at 08:03 -0400, Paul Tilles wrote: When is the next release of 8.2 expected to occur? http://archives.postgresql.org/pgsql-general/2007-08/msg01803.php Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services

Re: [GENERAL] Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)

for semafores are kernel.sem = 250 32000 100 128 You should increase shmmax. Add this to sysctl.conf: kernel.shmmax=$TheValueYouNeed (and then run sysctl -p) Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated

[GENERAL] New PostgreSQL RPM sets are available for Fedora / RHEL

/ http://www.postgresql.org/ftp/binary/v7.4.18/linux/ http://www.postgresql.org/ftp/binary/v7.3.20/linux/ Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http

Re: [GENERAL] PgpoolAdmin installation

Hi, On Tue, 2007-09-25 at 12:57 +0530, Ashish Karalkar wrote: can anybody please tell me what is this PCP and PCP directory, I dont have that one on my box,do i have to install this pcp package and if yes please point me to the link? Did you install pgpool-II ? Regards, -- Devrim GÜNDÜZ

Re: [GENERAL] PgpoolAdmin installation

any phpinfo.php file in the install directory. No idea, but AFAICS there is no need for that file. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http

Re: [GENERAL] Yum Repository for Postgres 8.2.5

other priorities nowadays. I think it will be available next weekend or so. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc

Re: [GENERAL] 2 versions running using pg_dumpall

Hi, On Thu, 2007-10-25 at 15:36 -0700, Ralph Smith wrote: [EMAIL PROTECTED]:/usr/lib/postgresql/7.4/bin$ ./psql -p 5433 psql: FATAL: database postgres does not exist 7.4 does not have postgres database. use ./psql template1 -p 5433. -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting

Re: [GENERAL] real multi-master replication?

development right now. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part

Re: [GENERAL] real multi-master replication?

thought it was PGCluster. At least this is what I understood from the drawings. -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc

Re: [GENERAL] Postgres Mailing List management solution

in PostgreSQL. We were dumping user data in mailman's format regulary (silent unsub/silent resub). I know it is a pain, but it was working (BTW, we were using our own subcription page). Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed

Re: [GENERAL] oracle to postgresql conversion

Hi, On Fri, 2007-03-09 at 05:21 +1030, Shane Ambler wrote: NUMBER is Oracle's version of NUMERIC - Oracle will use both but probably only Oracle will use NUMBER. Really? I thought Oracle's NUMBER ~ PostgreSQL's (BIG)INT? /me looks at Oracle docs again. -- Devrim GÜNDÜZ PostgreSQL

Re: [GENERAL] Configuring phpPgAdmin and pg_ctl reload

Hi, On Wed, 2007-03-21 at 21:01 -0600, John Meyer wrote: pg_ctl reload pg_ctl: no database directory specified and environment variable PGDATA unset You should use pg_ctl -D /path/to/your/data/dir reload See man page for details. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication

Re: [GENERAL] Problem on installing postgresql-devel

Hi, On Thu, 2007-03-22 at 15:56 +0800, Stephen Liu wrote: Please advise how to fix the problem. You should either complain to CentOS guys, or use PGDG RPMs... Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated

Re: [GENERAL] redhat debug info

whether to upload their debuginfo RPMs to the PG servers. They may feel it's mostly a waste of bandwidth. Exactly. I don't want to upload a package which is really big. Anyway, the short answer is to download the source RPM and build it for yourself ... Yes, agreed. Regards, -- Devrim GÜNDÜZ

Re: [GENERAL] CentOS 5, pg8.4.2, could not read time zone file

release. I could install and use RHEL5 PGDG RPMs on CentOS 5, btw. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description

Re: [GENERAL] Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

he feels better -- but no up2date news until then. AFAIK, PGCluster-II is ready for testing, but SRA Europe guys will be doing an internal test before making the code public. He will be talking at PGCon, so we may expect to see some piece of code by the end of this month. Regards, -- Devrim GÜNDÜZ

Re: [GENERAL] jdbc pg_hba.conf error

/docs/current/static/client-authentication.html Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally

[GENERAL] First cut for 8.3 RPM set

Hello, http://developer.postgresql.org/~devrim/rpms/v8.3devel/ is the SRPM that I built using yesterday's CVS snaphot (the tarball in FTP site). This is for the people who want to test 8.3+RPM in their distros. Please let me know if you find packaging errors. Regards, -- Devrim GÜNDÜZ

Re: [GENERAL] POLL: Women-sized t-shirts for PostgreSQL

Hi, On Thu, 2007-11-22 at 01:34 -0600, Scott Marlowe wrote: Just adding one more request for the polo shirt. L or XL if they run small. + some XXL please. :) -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated

[GENERAL] Announcing PostgreSQL RPM Buildfarm

thanks go to Darcy Buskermolen, my colleague at Command Prompt, for providing hardware, building Xen infastructure and spending countless, countless and countless hours on it. Thanks Darcy. (Thanks again). Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7

[GENERAL] Announcing PostgreSQL RPM Yum Repository

. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Announcing PostgreSQL RPM Buildfarm

Hi, On Mon, 2008-01-07 at 22:59 +0100, Peter Eisentraut wrote: I want to announce PostgreSQL RPM Buildfarm today. Where is it? You mean the server? Here it is: http://yum.pgsqlrpms.org/rpmbuildfarm.php :-) Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom

Re: [GENERAL] Announcing PostgreSQL RPM Buildfarm

Hi, On Mon, 2008-01-07 at 19:12 -0500, [EMAIL PROTECTED] wrote: what is a botherboard? Brotherboard -- motherboard is a bit old. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors

Re: [GENERAL] Announcing PostgreSQL RPM Buildfarm

. -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Announcing PostgreSQL RPM Buildfarm

Hi, On Tue, 2008-01-08 at 14:15 +0800, Ow Mun Heng wrote: I packaged it last month, but did not announce it to public.:) Hmm.. can I find it in the same location as the pgpool rpms? No, please wait until it appears in our yum repository. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL

[GENERAL] PostgreSQL 8.3.0 RPMs are available for download

these resources for issues running or using PostgreSQL once it is installed. Please download these files from: http://www.postgresql.org/ftp/binary/v8.3.0/linux/ Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared

Re: [GENERAL] PostgreSQL 8.3.0 RPMs are available for download

this e-mail to Reinhard, who is (still?) responsible for PostgreSQL packaging @ SuSE. You are welcome to switch to Fedora/RHEL/CentOS btw ;) Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co

Re: [GENERAL] RHEL3 configure ssl

. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Upgrade to 8.3.0?

Hi, On Fri, 2008-02-29 at 21:31 +, Shane Wright wrote: I'm assuming that the default RPMs for RHEL 4 (on ftp.postgresql.org) are not built with --enable-cassert Yeah, --enable-cassert is enabled only in beta packages. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting

Re: [GENERAL] Build 8.3 with OpenSSL on CentOS 5.x?

meant openssl-devel ? Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

Hi, On Fri, 2008-03-07 at 13:56 -0800, Josh Berkus wrote: He's also not the sole admin of planetpostgresql.org. I am. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

, but this is really... err. stupid. I thought that noone involving in PostgreSQL project was narrow-minded. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

, we have some alternatives like feedburner. If asked politely, I'm happy to help anyone. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

the technical issues -- I'm talking about the policy stuff. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

Hi, On Fri, 2008-03-07 at 14:26 -0800, Devrim GÜNDÜZ wrote: Nope, but it does cover us if you get sick or something. I'm not talking about the technical issues -- I'm talking about the policy stuff. BTW: When someone wants to land Planet PostgreSQL, I forward this request to planet

Community websites (Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs)

Hi, Either please change the subject, or let's move this discussion to -www, with a different subject. Thanks. -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http

Re: [GENERAL] gsoc ideas

, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Relocation error: /usr/lib/libpq.so.5: undefined symbol: krb5_cc_get_principal

/rpms/ or http://yum.pgsqlrpms.org/ If your Linux distro is not among the listed ones, you will need to rebuild the SRPM: http://www.postgresql.org/ftp/binary/v8.2.6/linux/srpms/ -HTH. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: [GENERAL] Relocation error: /usr/lib/libpq.so.5: undefinedsymbol: krb5_cc_get_principal

Hi, On Tue, 2008-03-11 at 11:53 -1000, Tri Quach wrote: Our server is Red Hat Enterprise Linux 4 (64-bit). [EMAIL PROTECTED] lm-9.3b-pgsql-linux-rh-enterprise_3]# ^ RHEL 3 or RHEL 4? Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication

Re: [GENERAL] Relocation error: /usr/lib/libpq.so.5:undefinedsymbol: krb5_cc_get_principal

/148/1338/PostgreSQL-RPM-Installation-PGDG.pdf -HTH. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description

Re: [GENERAL] 8.3.0 upgrade

://yum.pgsqlrpms.org/rpmchart.php Then click to C at the top, and download the compat package. Also, you can use that repository, so that it will take care of the dependencies: http://yum.pgsqlrpms.org/howtoyum.php Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7

Re: [GENERAL] Which RHEL

Hi, On Wed, 2008-03-19 at 16:40 -1000, Tri Quach wrote: I am not sure which RHEL is on my server. cat /etc/redhat-release Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP

Re: [GENERAL] rpmbuild: command not found

Hi, On Wed, 2008-03-19 at 14:22 -1000, Tri Quach wrote: Does anyone know where I can download rmpbuild for RHEL 3? RHEL 3 - PostgreSQL 8.2.6 packages: http://www.postgresql.org/ftp/binary/v8.2.6/linux/rpms/redhat/rhel3.0/ We don't have 8.2.7, yet. Regards, -- Devrim GÜNDÜZ , RHCE

Re: [GENERAL] 8.3.0 upgrade

: [EMAIL PROTECTED] ~]# yum install php-pgsql snip -- Processing Dependency: libpq.so.3 for package: php-pgsql Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http

Re: [GENERAL] 8.3.0 upgrade

Hi, On Fri, 2008-03-21 at 14:37 -0500, Adam Rich wrote: I have applications that depend on libpq.so.4 Where do I get that, if not compat-postgresql-libs-4-2 ?? I'll send you instructions for how to build custom compat package. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication

Re: [GENERAL] PG Yum Repo - can't Find Slony1

. This is for Centos 5. I intentionally skipped Slony 1.2.13, and waiting for 1.2.14 to be released, so that I can push the packages. If you want, you can grab 1.2.13 SRPM from: http://developer.postgresql.org/~devrim/rpms/other/slony1/slony1-1.2.13-1.f8.src.rpm Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL

Re: [GENERAL] Installed pgadmin3-1.4.3 with 8.3.1 database..errors

://yum.pgsqlrpms.org/8.3/redhat/rhel-4-x86_64/repoview/pgadmin3.html or here: http://yum.pgsqlrpms.org/8.3/redhat/rhel-4-i386/repoview/pgadmin3.html depending on your arch. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services

Re: [GENERAL] libpq.so.4

/8.3/redhat/rhel-4-x86_64/repoview/compat-postgresql-libs.html and http://yum.pgsqlrpms.org/8.3/redhat/rhel-4-i386/repoview/compat-postgresql-libs.html now has compat-libs-postgresql-4 packages. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: [GENERAL] Source RPM for 8.3.3?

you can grab them from here: http://yum.pgsqlrpms.org/srpms/8.3/ Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc

Re: [GENERAL] Source RPM for 8.3.3?

/RHEL/CentOS packages, and I really want to use that one. Also, to be honest, I have *no* time to maintain another distro -- more spec file, more packages to build, etc. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared

Re: [GENERAL] Making a RPM installer

file or to init script. Same is valid for (3). Add those changes as a patch to RPM itself -HTH. -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Making a RPM installer

. -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] manual Installation for thread safety

. -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] apache permission denied

On Thu, 2008-07-10 at 11:49 -0700, Chris Cosner wrote: DBI connect('dbname=db','',...) failed: FATAL: role apache is not permitted to log in at /home/www/cgi-bin/db.lib line 1635 What about: ALTER ROLE apache LOGIN; -HTH. -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org

[GENERAL] A better error message for reject option in pg_hba.conf

and database template1 -- but it is a reject. Should we improve this message and return an error actually? ...or am I overlooking something? Regards, -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc

Re: [GENERAL] compat-postgresql-libs rpm bug in 64bit mode

/repoview/compat-postgresql-libs.html We both have 32 and 64 bit packages. Please make sure that you have 64-bit one installed. Regards, -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description

Re: [GENERAL] How to use postgresql-jdbc rpm with Sun JDK

#supported Regards, -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] compat-postgresql-libs rpm bug in 64bit mode

/lib64/libpq.so.4.1 [EMAIL PROTECTED] ~]# ll /usr/lib64/libpq.so.4 lrwxrwxrwx 1 root root 23 Aug 7 14:11 /usr/lib64/libpq.so.4 - /usr/lib64/libpq.so.4.1 Symlinking is done after installing package with a %post operation. I suggest you to create symlinks for yourself. -- Devrim GÜNDÜZ devrim

Re: [GENERAL] Postgres 8.3.x installation on Fedora 9 system

as the source --not our FTP site and its mirrors. Anyway, I am currently uploading Fedora-9 packages to ftp.postgresql.org. It will appear in the FTP site in a few hours. Regards, -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http

Re: [GENERAL] Postgres 8.3.x installation on Fedora 9 system

On Thu, 2008-08-07 at 17:24 -0400, Jack Orenstein wrote: Using pgdg-83-fedora.repo, yum finds two RPMs, postgresql-8.3.3-1PGDG.f9.i386 and postgresql-libs-8.3.3-1PGDG.f9.i386. Uh... Use yum search postgresql :) sudo yum search postgresql|wc -l 145 :) -- Devrim GÜNDÜZ devrim~gunduz.org

Re: [GENERAL] Newbie [CentOS 5.2] service postgresql initdb

/pgstartup.log file? -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Postgresql RPM upgrade (8.2.3 - 8.2.9)

would run these without the --test) Right now, these tests give errors. What errors? Also, I think you should update all packages at once, like: rpm -Uvh postgresql-server-8.2.9-1PGDG.rhel4.i386.rpm postgresql-8.2.9-1PGDG.rhel4.i386.rpm ... Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org

Re: [GENERAL] Slow PG after upgrade to 8.2.9!!

. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] upgrading from 8.1.4 to 8.3.3

. http://www.postgresql.org/docs/8.3/static/install-upgrading.html Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

[GENERAL] Testers: 8.4 snapshot RPMs are available

://www.postgresql.org/support/submitbug Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] You need to rebuild PostgreSQL using --with-libxml.

sources. RHEL ships 2.6.16 version of libxml, but PostgreSQL requires 2.6.23 at least. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Changes for version 8.4

On Thu, 2008-09-04 at 10:45 -0400, Alvaro Herrera wrote: Joao Ferreira gmail escribió: Is there a date for the release of 8.4 ? http://wiki.postgresql.org/wiki/PostgreSQL_8.4_Development_Plan /me notes that noone responded like It will be released when it is ready. -- Devrim GÜNDÜZ, RHCE

Re: [GENERAL] You need to rebuild PostgreSQL using --with-libxml.

. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

[GENERAL] New shapshot RPMs (Sep 7 2008) are ready for testing

them to [EMAIL PROTECTED] or fill out this form: http://www.postgresql.org/support/submitbug  Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed

Re: [GENERAL] [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing

it to 8.4 packages for Fedora 11. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing

://archives.postgresql.org/pgsql-committers/2008-03/msg00550.php You are right, and I overlooked the actual macro. I now fixed the macro by changing its behavior to use the --disable-integer-datetimes mode if not defined. Cheers, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org

Re: [GENERAL] You need to rebuild PostgreSQL using --with-libxml.

+ PostgreSQL 8.3.3, which include xml support? http://yum.pgsqlrpms.org Regards -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

is built on Fedora/RHEL, but I'm not sure why SLES skips it. I need that file for Slony-I on SLES,since AFAICS Slony version is 1.2.6 on SLES :-( I don't have access to that SLES server. I'll ask my friend to post the spec to me, and I'll let you know about the status. Regards, -- Devrim GÜNDÜZ

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

, too. This is not a very good spec file for me, but at least it compiles. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] postgres/postgis

. I am the maintainer of this repository. For details, you may want to visit: http://yum.pgsqlrpms.org Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally

Re: [GENERAL] postgres/postgis

in their repositories. -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Starting PostgreSQL

On Sun, 2008-10-12 at 00:03 +0930, admin wrote: psql: could not connect to server: No such file or firectory Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PDSQL.0? Socket file name is wrong -- and the port... -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org

Re: [GENERAL] 8.4 RPMs

are not using these distros, you won't find the packages. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

[GENERAL] New shapshot RPMs (Oct 11 2008) are ready for testing

Hi, Released new sets: http://people.planetpostgresql.org/devrim/index.php?/archives/124-New-shapshot-RPMs-Oct-11-2008-are-ready-for-testing.html Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org

Re: [GENERAL] bizgres

On Tue, 2009-05-05 at 10:04 +, Glyn Astill wrote: Can anyone point me at interesting tools they've used? You may want to contact Greenplum -- their product has the specifications that you asked. http://www.greenplum.com/ -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org

Re: [GENERAL] Good PG Books ?

/ Please note that many of them are not up2date. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Replication

On Mon, 2009-06-22 at 17:53 -0400, Gerry Reno wrote: We need something as good as MySQL Replication. Either you did not use MySQL Replication, or you don't know what good means... -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org

Re: [GENERAL] Replication

of decay/abandonment. There is no real replication available for postgresql. There are: http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling IIRC only Slony-II and PGCluster-II is abandoned. PGCluster-I is not up2date, but the others are being worked on. -- Devrim

Re: [GENERAL] Replication

friendly, come on. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] For production: 8.4 or 8.3?

On Tue, 2009-07-28 at 03:51 +0800, Phoenix Kiula wrote: Are people already using 8.4 in serious live hosting environments? Not yet. There are lots of (important) fixes in CVS which are waiting for 8.4.1. For production, I'd wait for a while. -- Devrim GÜNDÜZ, RHCE Command Prompt - http

Re: [GENERAL] Building from source vs RPMs

packages (RPMs, debs, etc) easier to administrate. Ubuntu, Debian, CentOS, Fedora and Red Hat has packages for many PostgreSQL versions. See here: http://www.postgresql.org/download/linux -HTH. Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim

Re: [GENERAL] For production: 8.4 or 8.3?

it by default. I think this will be the first time that we break compatibility between RH RPMs and PGDG ones. It is your playground, but *IMHO* you should not disable a switch that is on by PostgreSQL's default. Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim

Re: [GENERAL] For production: 8.4 or 8.3?

/current/static/release-8-3.html Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part

Re: [GENERAL] SVN and Postgres 8.3

of the compat packages -- they will give you libpq.so.4. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message

Re: [GENERAL] PostgreSQL for Firefox Bookmarks?

On Fri, 2009-08-14 at 00:20 +1000, Philip Rhoades wrote: It would be nice to be able to use PostgreSQL as the storage for Firefox Bookmarks - anyone know if this would be possible? how it could be done? Uh, I think it would consume more system resources. -- Devrim GÜNDÜZ, RHCE Command

Re: [GENERAL] 8.4 rpm packaging problem?

installed by just downloading and installing the right rpm, I notice the FAQ subdirectory contains the FAQ in many languages, but not english. Intentional? English FAQ moved to wiki -- it is not even in 8.4.0 tarball. That's why RPM's don't ship it. Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt

Re: [GENERAL] 8.4 rpm packaging problem?

On Sun, 2009-08-16 at 18:35 -0400, Alvaro Herrera wrote: Huh, but the tarball does not contain the FAQs in other languages either. See doc/src/FAQ directory in 8.4.0 tarball. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org

Re: [GENERAL] 2 versions of Postgres on the same machine

On Tue, 2009-08-18 at 02:16 -0700, wstrzalka wrote: Is there any clever way to install parallel version of PG using yum or other way (without compilation please :D ) There is no way to do it with RPMS :( Install one of the versions using yum, and compile the other please. -- Devrim GÜNDÜZ

Re: [GENERAL] question about /etc/init.d/postgresql in PGDG

/lib/pgsql/data fi Is it just me, or is the else extra noise? I haven't bothered to remove it (call me lazy). I will remove it in the upcoming sets. Thanks. Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz

Re: [GENERAL] question about /etc/init.d/postgresql in PGDG

to be prepared to work with postmaster versions that would be old enough for the if-test to succeed. I took the whole if-block out of the just-updated Fedora RPMs, and would recommend the same for PGDG. Done. It will appear in next set of releases. Thanks. Regards, -- Devrim GÜNDÜZ, RHCE Command

  1   2   3   4   5   >