Re: [GENERAL] CentOS initd Script

2012-09-12 Thread Devrim GUNDUZ
Hi, On Wed, September 12, 2012 5:54 pm, Scott Marlowe wrote: While RHEL is a solid and reliable OS, it was never built to run 1 version etc of pgsql easily. I would disagree with this. All you need is this: http://svn.pgrpms.org/browser/rpm/redhat/9.2/postgresql/EL-6/README.rpm-dist#L187

Re: [GENERAL] CentOS initd Script

2012-09-12 Thread Devrim GUNDUZ
Hi, On Wed, September 12, 2012 6:49 pm, Scott Marlowe wrote: Does RH support 1 cluster of the same version of postgres yet? Looking at the link I can't really tell. Looks like not. That link exactly tells you how to do that. Running 1 9.2 clusters in parallel. Regards, -- Temporarily

Re: [GENERAL] CentOS initd Script

2012-09-12 Thread Devrim GUNDUZ
Hi, On Wed, September 12, 2012 7:09 pm, Scott Marlowe wrote: Sorry wasn't clear. I meant does RH support running 1 cluster of the same version with simple commands from the command line. Like pg_createcluster does. Well, no. Except running cp /etc/init.d/postgresql-9.2

Re: [GENERAL] RPM contents for 9.2 community release.

2012-09-12 Thread Devrim GUNDUZ
Hi Jeremy, On Wed, September 12, 2012 6:23 pm, Jeremy Whiting wrote: I tried installing using the Direct Download RPMs for two systems I am using. The installation using the rpm files did not install in one case and the other did not install all files to the target directory I was

Re: [GENERAL] missing uuid functions in postgresql-contrib RPM for linux?

2010-06-23 Thread Devrim GUNDUZ
23.Haz.2010 tarihinde 17:53 saatinde, Andrew Geery andrew.ge...@gmail.com şunları yazdı: FWIW, I don't see the install script in the RHEL5 version RPM either: # rpm -qpl postgresql-contrib-8.4.4-1PGDG.rhel5.i386.rpm | grep -i uid

Re: [GENERAL] How to install 8.4 in Fedora 11 Leonidas

2010-06-18 Thread Devrim GUNDUZ
You will need to bump up minor version number, since that package was updated. Alternatively, you can read this: http://people.planetpostgresql.org/devrim/index.php?/archives/43-How-to-install-PostgreSQL-9.0-Beta-1-to-FedoraCentOSRHEL.html This also applies to 8.4 . Regards, -- Devrim

Re: [GENERAL] [HACKERS] urgent: upgraded to 8.2, getting kernel panics

2007-02-26 Thread Devrim GUNDUZ
Hi, On Mon, 2007-02-26 at 08:24 -0500, Merlin Moncure wrote: we tried update to the latest via yum update with no help. As Tom stated, FC4 is no more supported; therefore you won't be able to get newer kernel via yum. as promised, here is the best photo of the panic we could get:

Re: [GENERAL] urgent: upgraded to 8.2, getting kernel panics

2007-02-23 Thread Devrim GUNDUZ
On Fri, 2007-02-23 at 17:14 -0500, Merlin Moncure wrote: BUG: spinlock recursion CPU0 postmaster...not tainted. snip Has anybody seen any problem like this or have any suggestions about possible resolution...should I be posting to the LKML? AFAIR (+ some quick Googling), this is related

Re: [GENERAL] RPM compat-postgresql-libs-4-2 for IA-64

2007-02-20 Thread Devrim GUNDUZ
Hi, On Tue, 2007-02-20 at 09:14 +0100, DANTE Alexandra wrote: I propose to work off-list with you Devrim, so you could take the RPM and check them. Is it OK ? Ok for me :) Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services,

Re: [GENERAL] RPM compat-postgresql-libs-4-2 for IA-64

2007-02-19 Thread Devrim GUNDUZ
Hello, On Mon, 2007-02-19 at 16:49 +0100, DANTE Alexandra wrote: Where can I find the RPM compat-postgresql-libs-4-2 for RHEL4-AS and IA-64 ? Those libs are extracted from 8.1.X RPMs and put together to form an RPM package. If you can build and send us 8.1.8 RPMs, I can build and upload that

Re: [GENERAL] Keyword OWNED not recognized in pg v. 8.1

2007-02-15 Thread Devrim GUNDUZ
Hi, On Tue, 2007-02-13 at 08:57 +0100, dfx wrote: I tryied also with .rpm downloaded from postgres official site but I get a lot of unresolved dependencies. You should not have gotten dependency errors if you did not miss to install compat package. So I ask if it exist a document that

[GENERAL] [Security] New RPM Sets for Fedora Core / Red Hat Enterprise Linux

2007-02-08 Thread Devrim GUNDUZ
- PostgreSQL New RPM Sets 2007-02-08 Versions: 8.2.3, 8.1.8, 8.0.12 Set label: 8.2.3-1PGDG, 8.1.8-1PGDG, 8.0.12-1PGDG -

[GENERAL] New RPM Sets for Fedora Core / Red Hat Enterprise Linux

2007-02-05 Thread Devrim GUNDUZ
- PostgreSQL New RPM Sets 2007-02-05 Versions: 8.2.2, 8.1.7, 8.0.11, 7.4.16, 7.3.18 Set label: 8.2.2-1PGDG, 8.1.7-1PGDG, 8.0.11-1PGDG, 7.4.16-1PGDG, 7.3.18-1PGDG

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-01-27 Thread Devrim GUNDUZ
Hi, On Sat, 2007-01-27 at 08:41 +, Dave Page wrote: What do people think about that? Does anyone think it would be an unreasonable policy? I don't think so. You should build 8.0 binaries until the community stops maintaining PostgreSQL 8.0. This is what we do for RPMs -- I know it is

Re: [GENERAL] Postgresql 8.0.10 on FC4

2007-01-19 Thread Devrim GUNDUZ
Hi, On Fri, 2007-01-19 at 12:52 -0800, Dianne Yumul wrote: I downloaded the 8.0.10 rpms for FC4 yesterday and after installing it, postgresql won't start. I get the following error: An old version of the database format was found My previous postgresql version was 8.0.8 and I read

Re: [GENERAL] How I can read-back a serial value just inserted?

2007-01-18 Thread Devrim GUNDUZ
Hi, On Thu, 2007-01-18 at 10:01 -0600, Russ Brown wrote: lastval's main benefit is in aiding the port of MySQL apps (being a drop-in replacement for LAST_INSERT_ID()). without lastval such ports can be really difficult. I think one can also use INSERT/UPDATE...RETURNING that appeared in

Re: [GENERAL] apt-get install postgresql.deb??

2007-01-18 Thread Devrim GUNDUZ
Hi, On Thu, 2007-01-18 at 14:17 -0700, [EMAIL PROTECTED] wrote: how to get postgresql 8* debian package?? 8.0 and 8.1 are in Debian repos. If you are looking for 8.2.1, visit here: http://packages.qa.debian.org/p/postgresql-8.2.html Regards, -- The PostgreSQL Company - Command Prompt, Inc.

Re: [GENERAL] uninstalling postgre sql on Fedora core 5

2007-01-18 Thread Devrim GUNDUZ
Hi, On Fri, 2007-01-19 at 14:07 +1100, Chris wrote: rpm -qa | grep -i 'postgres' find the package names, then rpm -e pkg1 pkg2 pkg3 etc or: rpm -e `rpm -qa|grep postgresql` Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting,

Re: [GENERAL] installing 8.2 on solaris 10?

2007-01-13 Thread Devrim GUNDUZ
Hi, On Fri, 2007-01-12 at 21:21 -0800, Joshua D. Drake wrote: Is there a prebuilt package available for solaris 10 somewhere or should I just follow the instructions here: http://www.postgresql.org/docs/8.2/interactive/install-procedure.html ? I have only seen up to 8.1.4. I would

Re: [GENERAL] Backup and restore UTF8 data

2007-01-12 Thread Devrim GUNDUZ
On Fri, 2007-01-12 at 16:02 -0800, Benjamin Arai wrote: psql:outfile:151275: ERROR: invalid byte sequence for encoding UTF8: 0x92 Does anybody know what I can do to fix this? Here is a copy-paste from 8.1 release notes: ==

Re: [GENERAL] Web interface to update/change postgres data.

2007-01-08 Thread Devrim GUNDUZ
Hi, On Mon, 2007-01-08 at 05:36 -0800, Ravi Malghan wrote: I want to create a simple web interface that lists table data, select entries to add/delete/change table data from a table in postgres database. Whatz the best and easiest way to do this? You can use phpPgAdmin:

Re: [GENERAL] Dependency conflicts on CentOS 4.4

2007-01-05 Thread Devrim GUNDUZ
Hi, On Fri, 2007-01-05 at 07:33 +0100, Gunnar Wagenknecht wrote: Thanks, it worked. But I had to remove compat-postgresql-libs-4-2PGDG.rhel4.i686.rpm for this one to work. What if some client needs libpq.so.4? I had the same issue in my box a few days before. I had to do rpm -ivh --force .

Re: [GENERAL] Slony across platforms

2007-01-05 Thread Devrim GUNDUZ
Hi, On Fri, 2007-01-05 at 21:54 +, Raymond O'Donnell wrote: Would there be any problem with using Slony-I to replicate from a Windows server to Linux? Has anyone done this? I haven't tried this; but it should work, I think. Also, is there a mailing list for Slony?

Re: [GENERAL] Continue sequence

2007-01-05 Thread Devrim GUNDUZ
Hi, On Fri, 2007-01-05 at 11:13 -0200, Wilton wrote: Which is the correct way to obtain a continue sequence without fail (hole/gap) for a composite-id ? http://www.varlena.com/GeneralBits/130.php may help you. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564

Re: [GENERAL] Moving from 7.2.1 to 8.1.5 - looking for jdbc

2007-01-04 Thread Devrim GUNDUZ
Hi, On Thu, 2007-01-04 at 22:10 +0530, Arindam wrote: I was actually looking for a more extensive list of changes which have happened between these two versions. Is there a place that can help? See the release notes: http://www.postgresql.org/docs/8.1/static/release.html You will need to

Re: [GENERAL] pg_dump question

2007-01-04 Thread Devrim GUNDUZ
Hi, On Thu, 2007-01-04 at 11:20 -0500, Madison Kelly wrote: As far as I can tell, you can only dump one schema at a time. Is this true? You can dump multiple schemas and multiple tables at a time with 8.2. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564

Re: [GENERAL] Dependency conflicts on CentOS 4.4

2007-01-04 Thread Devrim GUNDUZ
Hi, On Thu, 2007-01-04 at 16:57 +0100, Gunnar Wagenknecht wrote: Do I need to look for a different 'perl-DBD-Pg' that doesn't depend on 'libpq.so.3' or should 'libpq.so.3' be provided by 'postgresql-libs-8.2.0-2PGDG.i686.rpm'? Install this package:

Re: [GENERAL] Clustering Load Balancing Replication

2006-12-26 Thread Devrim GUNDUZ
On Tue, 2006-12-26 at 15:11 +, Andy Dale wrote: ... You guys please avoid top-posting. -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP,

Re: [GENERAL] xml2 install problem

2006-12-20 Thread Devrim GUNDUZ
Hi Paul, On Wed, 2006-12-20 at 14:07 -0800, Paul Silveira wrote: ok. tried to install the correct libs and then do it but still same errors. Here is where I am now... # installed both rmp's that were necessary... rpm -i

Re: [GENERAL] xml2 install problem

2006-12-19 Thread Devrim GUNDUZ
Hi Paul, On Tue, 2006-12-19 at 15:06 -0800, Paul Silveira wrote: xslt_proc.c:18:26: libxslt/xslt.h: No such file or directory You need to install libxslt-devel or libxslt-dev . Cheers, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom

Re: [GENERAL] anyone got any suggestions for clustering?

2006-12-18 Thread Devrim GUNDUZ
Hi, On Tue, 2006-12-19 at 16:47 +1000, CARMODA wrote: I am currently investigating the preferred method of clustering a postgresql database on Redhat? snip we already have licences for Redhat Enterprise Linux ES v4, i was wondering if Redhat's Cluster Manager is a candidate? Using RHEL +

Re: [GENERAL] Questions about postgresql-8.2.0-2PGDG.src.rpm

2006-12-08 Thread Devrim GUNDUZ
Hello, On Fri, 2006-12-08 at 11:59 +0100, DANTE Alexandra wrote: I am still trying to generate RPM for an IA-64 server with Red Hat Enterprise Linux 4 AS and today, I got a question about the postgresql-8.2.0-2PGDG.src.rpm. We are working off-list with Alexandra and will inform the list as

Re: [GENERAL] how to install 8.2 with yum on centos 4?

2006-12-07 Thread Devrim GUNDUZ
Hi, On Wed, 2006-12-06 at 23:32 -0800, [EMAIL PROTECTED] wrote: I got installed on my windows box and my debian box. But is there a way to install 8.2 on centos 4 using yum? I am about to create a yum repo for PGDG RPM sets. Clodoaldo Pinto Neto sent me the instructions on how to create

Re: [GENERAL] Error in installing compat-postgresql-libs rpm

2006-12-06 Thread Devrim GUNDUZ
Hi, On Wed, 2006-12-06 at 16:43 +0800, Leonard Soetedjo wrote: I'm trying to install PostgreSQL 8.2.0 ony my development box using rpm on CentOS 4.4. Currently I'm stuck at installing compat-postgresql-libs with the following error: libc.so.6(GLIBC_2.4) is needed by

Re: [GENERAL] Error in installing compat-postgresql-libs rpm

2006-12-06 Thread Devrim GUNDUZ
Hi, On Wed, 2006-12-06 at 13:14 +0100, Albe Laurenz wrote: I have notified the packager and hope that the problem will be fixed soon. After thinking about it a bit, I thought it is the only solution to prepare different RPMs per platform :-( Per this, I built new packages for RHEL4 for both

Re: [GENERAL] Error in installing compat-postgresql-libs rpm

2006-12-06 Thread Devrim GUNDUZ
Hi, On Wed, 2006-12-06 at 15:39 +0100, Bernhard Weisshuhn wrote: error: unpacking of archive failed on file /usr/lib64/libpq.so.4;4576d3af: cpio: MD5 sum mismatch Please download the RPM from another mirror, or re-download it. I could not duplicate that error. Is the srpm for

Re: [GENERAL] Error in installing compat-postgresql-libs rpm

2006-12-06 Thread Devrim GUNDUZ
Hi, On Wed, 2006-12-06 at 16:32 +0100, Bernhard Weisshuhn wrote: I don't get it. Per offlist discussion with Bernhard (thanks again for your patience and detailed testing), we now have the correct RPM. It is tagged as fc6.x86_64 and will hit the main FTP site shortly. It seems a weird

Re: [GENERAL] Error in installing compat-postgresql-libs rpm

2006-12-06 Thread Devrim GUNDUZ
Hi, On Wed, 2006-12-06 at 16:55 +0200, Devrim GUNDUZ wrote: Is the srpm for compat-postgresql downloadable somewhere? I don't plan to upload them somewhere, because: After thinking a bit (and talking with Alvaro and Magnus), I decided to put them to main FTP site. They are under binary

Re: [GENERAL] [Slony1-general] Please help... syntax Error in create set ..

2006-11-30 Thread Devrim GUNDUZ
Hi, On Thu, 2006-11-30 at 00:12 -0800, Ashish Karalkar wrote: create set (id=2, origin=1, comment='All tables'); but it gives error syntax error near unexpected token `(' That command must be passed to slonik, not to bash. Here is an example: #!/bin/bash slonik _END_ cluster name =

[GENERAL] Need testers for 8.2 RC1 RPMs

2006-11-30 Thread Devrim GUNDUZ
Hello, (Sorry for the cross-posting) Today, I have built PGDG RC1 SRPM; as well as RPMs for RHEL 4 and Fedora Core 6 packages for x86 and x86_64. They will be on main FTP site for testing in an hour. I hope to upload more packages for wide testing; but these should be enough at least for now.

Re: [GENERAL] PostgreSQL RPMs

2006-11-17 Thread Devrim GUNDUZ
Hi, On Wed, 2006-11-08 at 17:56 -0700, Leonel Nunez wrote: I've seen that the 8.1.5-6 rpms are available. Are those RPMs corrected from the announced bug ? Yes. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development,

Re: [GENERAL] empty folder for downlaoding PostgreSQL 8.1.5 for FC

2006-11-15 Thread Devrim GUNDUZ
Hello, On Wed, 2006-11-15 at 13:37 +0530, surabhi.ahuja wrote: Installing /gsp-dist/blr/developer/surabi/PostgreSQL8.1.5/postgresql-8.1.5-6PGDG.src.rpm error: unpacking of archive failed on file /usr/src/redhat/SOURCES/postgresql-8.1.5.tar.bz2;455ac7b9: cpio: read error:

Re: [GENERAL] empty folder for downlaoding PostgreSQL 8.1.5 for FC4

2006-11-15 Thread Devrim GUNDUZ
Hi, On Thu, 2006-11-16 at 10:47 +0530, surabhi.ahuja wrote: error: Failed build dependencies: tcl-devel is needed by postgresql-8.1.5-6PGDG.x86_64 It says I need tcl-devel RPM in order to build this package. Install tcl-devel RPM. Regards, -- The PostgreSQL Company - Command Prompt,

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-06 Thread Devrim GUNDUZ
Hi, On Mon, 2006-11-06 at 21:04 +0530, Sandeep Kumar Jakkaraju wrote: The site u gave me has .. has postgis rpm ..but it needs postgres-7.4 !! i need postgis rpm for postgres-8.1.5 So use the SRPMs to build RPMs for you. I don't have 7.4+RHEL4 around to build you an RPM for that. :(

Re: [GENERAL] upgrade to 8.0.9

2006-11-05 Thread Devrim GUNDUZ
Hi, On Mon, 2006-11-06 at 10:58 +0530, surabhi.ahuja wrote: I am currently using 8.0.0 and I want to upgrade to 8.0.9 Please tell if i can just install the rpms for 8.0.9 http://www.postgresql.org/ftp/binary/v8.0.9/linux/rpms/ Regards, -- The PostgreSQL Company - Command Prompt, Inc.

Re: [GENERAL] PostGIS Binary RPM for Red Hat Linux

2006-11-04 Thread Devrim GUNDUZ
Hello, On Sat, 2006-11-04 at 13:21 +0530, Sandeep Kumar Jakkaraju wrote: I am unable to find PostGIS Binary RPM for Red Hat Linux ...on the postgis.org website ... Can somebody point me to the url from where i can download ...this ?? I am assuming that you want RPMs for RHEL, not RHL.

Re: [GENERAL] postgresql and reiserfs

2006-10-31 Thread Devrim GUNDUZ
Hi, On Tue, 2006-10-31 at 09:31 -0800, Richard Broersma Jr wrote: I heard that reiser4 is not yet stable. And that there is a chance that it wont be since its author is in detention. Here are the links: http://linux.slashdot.org/linux/06/10/15/0057203.shtml

Re: [GENERAL] 8.1.5 RPMS

2006-10-30 Thread Devrim GUNDUZ
Hi, On Mon, 2006-10-30 at 09:17 -0700, Leonel Nunez wrote: is it safe to go back to 8.1.4 ? or can we safely wait for the fix ? If it is a fresh install, then it will probably not work for you. It sets a wrong homedir for postgres user. However, if this is an upgrade, then there will be no

Re: [GENERAL] Send email from PostgreSQL, may I ?

2006-10-27 Thread Devrim GUNDUZ
Hi, On Fri, 2006-10-27 at 11:11 +, Gerson Machado wrote: I need send email directly from PG with on function, where locate this ? You can send e-mails via pltclu or plperlu, more is also possible. http://sourceforge.net/projects/pgmail/ - This is tcl one. plperlu one is attached. I don't

Re: [GENERAL] plpython.so

2006-10-27 Thread Devrim GUNDUZ
Hi, On Fri, 2006-10-27 at 11:46 -0400, Tom Lane wrote: Also, the .so is probably in the postgresql-pl RPM not postgresql-python, unless Devrim has moved things around when I wasn't looking. Yeah, it is my mistake :-( I had removed plpython.so from installed files :( Sorry Cladoaldo and

Re: [GENERAL] plpython.so

2006-10-27 Thread Devrim GUNDUZ
Hi, On Fri, 2006-10-27 at 13:55 -0300, Clodoaldo Pinto Neto wrote: Is it a problem if i use plpython.so from 8.1.4? I don't know. We need to check commit logs for plpython. Anyway... I have uploaded new sets. SRPMs and FC5 RPMs will be in main FTP site in an hour. They are labeled as

Re: [GENERAL] plpython.so

2006-10-27 Thread Devrim GUNDUZ
Hi, On Fri, 2006-10-27 at 22:37 +0300, Devrim GUNDUZ wrote: Anyway... I have uploaded new sets. SRPMs and FC5 RPMs will be in main FTP site in an hour. They are labeled as 8.1.5-4PGDG It is really a nightmare... David Fetter has just found a problem that breaks 64 bit builds. I have updated

Re: [GENERAL] Problem compiling PostGIS 1.1.4

2006-10-11 Thread Devrim GUNDUZ
Hello, On Tue, 2006-10-10 at 11:30 +0200, Ludwig Kniprath wrote: /usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1: libgeos_c.so.1: cannot open shared object file: No such file or directory Did you run make install agains geos? Is the path that libgeos_c.so.1 lives in ldconfig path? Regards, --

[GENERAL] Status on Fedora Core Extras packaging

2006-08-30 Thread Devrim GUNDUZ
Hello, Yesterday night, I was approved (sponsored) for Fedora Core packaging (please note that this is not something financial). For the beginning, I officially submitted python-psycopg2 to FC6. More are on the way; like pgpool, Slony-I, pgadmin3-adminpacks, phpPgAdmin, postgresql_autodoc,

Re: [GENERAL] Where did the compat-postgresql-libs rpm get to?

2006-08-01 Thread Devrim GUNDUZ
Hello, On Tue, 2006-08-01 at 14:51 +, Karl O. Pinc wrote: Whatever happened to the rpm packaging of the 7.x libpq? (Which enabled programs linked against the old libraries to be used with a 8.x. postgresql.) http://developer.postgresql.org/~devrim/rpms/compat/ Regards, -- The

Re: [GENERAL] error while installing the 8.1.4 rpms on my m/c

2006-06-28 Thread Devrim GUNDUZ
Hi, On Wed, 2006-06-28 at 18:20 +0530, surabhi.ahuja wrote: failed dependency librealdline.so.5 is needed by postgresql-8.1.4-1PGDG.i686.rpm yum install readline Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom

Re: [GENERAL] planning to upgrade to 8.1

2006-06-27 Thread Devrim GUNDUZ
Hi, On Tue, 2006-06-27 at 20:49 +0530, surabhi.ahuja wrote: it is ok if i uninstall the current version of postgres 8.0.0 No. Please read this before you proceed: http://pgfoundry.org/docman/?group_id=148 i am trying to install the rpms for 8.1.4 FC(4) Where can i find the

Re: [GENERAL] new user (need help: fedora core 4)

2006-06-14 Thread Devrim GUNDUZ
Hi Jasbinder, On Wed, 2006-06-14 at 12:13 -0400, Jasbinder Bali wrote: How do i actually work on the database after starting the postgres service at the command line. Use pgadmin3: http://www.pgadmin.org This is a powerful gui for PostgreSQL. We have a prebuilt RPM for Fedora Core 4:

Re: [GENERAL] Binary Packages

2006-05-28 Thread Devrim GUNDUZ
Hi, On Wed, 2006-05-24 at 13:53 -0600, Leonel Nunez wrote: are the packaged rpms with the upgraded drivers ??? Yes and no. I'll give a resping as soon as PyGreSQL guys release a new version. Wait for the announcement in this list. Regards, -- The PostgreSQL Company - Command Prompt, Inc.

Re: [GENERAL] drop user / role if exists

2006-05-21 Thread Devrim GUNDUZ
Hi, On Sun, 2006-05-21 at 02:25 -0700, P.M wrote: And when i run the SQL script, PostgreSQL stops just on first errorso if user does not exist, my script is not any longer run :-( I think you are running your query inside a transaction. Remove the BEGIN and COMMIT parts... -- The

Re: [GENERAL] How to add plPHP to Postgresql

2006-05-07 Thread Devrim GUNDUZ
Hi, On Sun, 2006-05-07 at 15:33 -0300, Alejandro Michelin Salomon ( Adinet ) wrote: How to add the plPHP to the postgresql server, without recompiling the server? See the wiki for that information: http://projects.commandprompt.com/public/plphp/wiki

Re: [GENERAL] For vim users: Syntax highlighting for PostgreSQL

2006-05-02 Thread Devrim GUNDUZ
Hi, On Mon, 2006-05-01 at 15:15 -0700, [EMAIL PROTECTED] wrote: Thank you! I find this useful and am testing it. Great to hear that. I'm also working on plpgsql.vim file. Should feedback go to this thread in the newsgroup or to your email account or another channel? I think e-mail to me

Re: [GENERAL] pg_dump warings

2006-04-30 Thread Devrim GUNDUZ
Hi, On Sun, 2006-04-30 at 21:42 +, Rick Ellis wrote: I did something foolish and now I'm getting warnings every time pg_dump runs (hourly from cron). Anybody have a suggestion on how to fix this? Create the user again with the same userid (I mean revert what you did). You can get this

[GENERAL] For vim users: Syntax highlighting for PostgreSQL

2006-04-27 Thread Devrim GUNDUZ
Hi, I just wrote a pgsql.vim file for vim users. It helps you to colorize the file which contains PostgreSQL SQL keywords: http://www.gunduz.org/postgresql/pgsql.vim In order to use this file, first edit filetype.vim file and add PgSQL au BufNewFile,BufRead *.pgsql

[GENERAL] Question about partitioning

2006-04-17 Thread Devrim GUNDUZ
Hi, I am writing a tutorial (in Turkish) on partitioning and I have a question that I could not find the answer of. http://www.postgresql.org/docs/8.1/static/ddl-partitioning.html This doc suggests to write a rule in order to be sure that data is entered to the latest partition. Also it says

Re: [GENERAL] Question about partitioning

2006-04-17 Thread Devrim GUNDUZ
Hi, On Mon, 2006-04-17 at 15:43 +0300, Devrim GUNDUZ wrote: I have a question that I could not find the answer of. Next time I'll scroll down a bit to find my answer. Sorry for the noise. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication

Re: [GENERAL] RH9 postgresql 8.0.7 rpm

2006-04-12 Thread Devrim GUNDUZ
Hi, On Wed, 2006-04-12 at 12:24 +0200, Gaetano Mendola wrote: I thought given this link http://www.postgresql.org/ftp/binary/v8.0.7/linux/srpms/redhat/redhat-9/ is not empty RH9 was still supported. PostgreSQL is built on Red Hat 9; but we (RPM packagers) can't provide RPMs now, because

Re: [GENERAL] [HACKERS] RH9 postgresql 8.0.7 rpm

2006-04-12 Thread Devrim GUNDUZ
Hi, On Wed, 2006-04-12 at 13:07 +0200, Gaetano Mendola wrote: I was able to create it with: --nodeps --define 'buildrhel3 1' --define 'build9 1' I'll be hppy if you send the RPMs directly to me; so that I can upload them. A tarball would be fine. Regards, -- The PostgreSQL Company -

[GENERAL] IA64 RPMs for 8.1.3

2006-04-12 Thread Devrim GUNDUZ
Hi -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/ ---(end of

[GENERAL] IA64 RPMs for 8.1.3

2006-04-12 Thread Devrim GUNDUZ
Hi, I've just built 8.1.3 RPMs for IA64. The platform is Red Hat Enterprise Linux Advanced Server 4 for Itanium. The RPMs should be on main FTP site very soon. I'll upload 8.0.7 binaries tomorrow. Please let me know if you have problems with these binaries. Regards, -- The PostgreSQL Company

Re: [GENERAL] Cannot connect Postgresql 8.1 64 bit

2006-04-08 Thread Devrim Gunduz
Hi, On Sun, 2006-04-09 at 05:30 +0700, [EMAIL PROTECTED] wrote: I try to set FC3 X64 and postgresql 64 8.1 in my new server but I cannot connect it with pgadminIII. My pg_hba.conf is like below: # local is for Unix domain socket connections only local all all

Re: [GENERAL] Looking for good PostgreSQL hosters

2006-04-05 Thread Devrim GUNDUZ
Hi, On Wed, 2006-04-05 at 10:16 +, Frank Church wrote: I am looking for service providers that offer postgresql hosting. We, at Command Prompt, provide PostgreSQL hosting: http://www.commandprompt.com/services/sharedhosting/ For other companies, please visit:

Re: [GENERAL] 8.1.3's /etc/init.d/postgresql fails, logging

2006-04-05 Thread Devrim GUNDUZ
Hi, On Wed, 2006-04-05 at 09:53 -0400, Jonathan Beit-Aharon wrote: I cannot find any documentation of this situatio Which distro is this? -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services,

Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1

2006-03-27 Thread Devrim GUNDUZ
Hi, On Mon, 2006-03-27 at 06:03 -0600, Jim C. Nasby wrote: I'd hope that RH would support at least the most recent version of 7.4, since presumably that's part of what they pay Tom for... Just understand that 7.4 is approaching end-of-life. (Presumably so is RHEL2...) RH won't support a

[GENERAL] Planet PostgreSQL : Do you want to blog?

2006-03-25 Thread Devrim GUNDUZ
Hi, We currently have 28 bloggers in Planet PostgreSQL (http://PlanetPostgreSQL.org ), and we hope to grow more. For the people who want to blog on PostgreSQL, but does not have a blogging area, we provide a space: http://people.PlanetPostgreSQL.org . If you think you are interested, please

Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1

2006-03-24 Thread Devrim GUNDUZ
Hi, On Fri, 2006-03-24 at 07:52 -0800, Leon Pu wrote: I found the newest PostgreSQL binary download on Redhat Advance Server 2.1 is version 7.4.7. http://www.postgresql.org/ftp/binary/OLD/v7.4.7/rpms/redhat/rhel-es-2.1/ But I want to install newer PostgreSQL in Redhat Advance Server 2.1,

Re: [GENERAL] where to find pg_config....

2006-03-23 Thread Devrim GUNDUZ
Hi, On Fri, 2006-03-24 at 01:16 -0600, Clyde Swann wrote: running fedora 2... just installed postgresql 7.4.12 from postgresql website because the version that came with fedora core 2 did not have the pg_config in postgres-devel. now this one does not either. what gives? Fedora Core 2

Re: [GENERAL] question about the admin contrib module and binary

2006-03-22 Thread Devrim GUNDUZ
Hi, On Wed, 2006-03-22 at 13:31 -0600, Tony Caduto wrote: I just updated my CentOS box to Postgresql 8.1.3 and installed the contrib rpm and I can't find the admin81 stuff anywhere. My question is how come this is not included in the RPM based binary distrubution? Admin81 stuff is not a

Re: [GENERAL] question about the admin contrib module and binary

2006-03-22 Thread Devrim GUNDUZ
Hi, On Wed, 2006-03-22 at 15:52 -0600, Tony Caduto wrote: All I am trying to say is that it should be included in this file: postgresql-contrib-8.1.3-1PGDG.i686.rpm so binary linux users can use it almost as easy as the binary win32 users. It won't happen, because adminpack is not in

Re: [GENERAL] Postgresql won't run after upgrade to fc5

2006-03-21 Thread Devrim GUNDUZ
Hi, On Tue, 2006-03-21 at 17:02 -0500, Jerry LeVan wrote: I accidently upgraded my linux/intel to fc5 from fc4 and something happened... Postgres cannot find some needed shared libraries any more. We (PGDG) don't have RPMs for FC5 yet. However Fedora Core ships with 8.1.3 RPMs already. So

Re: [GENERAL] Postgresql won't run after upgrade to fc5

2006-03-21 Thread Devrim GUNDUZ
Hi, On Tue, 2006-03-21 at 17:38 -0500, Jerry LeVan wrote: I might try moving the old versions from an existing fc4 over to fc5. Don't do that. You may break he consistency of your new box. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication,

Re: [GENERAL] Can the PostgreSQL store the Multimedia files

2006-03-15 Thread Devrim GUNDUZ
Hi, On Fri, 2006-03-10 at 08:47 -0800, [EMAIL PROTECTED] wrote: - Can the PostgreSQL store the Multimedia files ( Images ,video ,audio)??and exactly how?? Yes. The keyword is large object. pleaze I want the answer very fast Was that fast enough? -- The PostgreSQL Company - Command

Re: [GENERAL] Clustered PostgreSQL

2006-03-14 Thread Devrim GUNDUZ
Hi, On Tue, 14 Mar 2006, Jojo Paderes wrote: Is it possible to cluster PostgreSQL? If yes where can I find the resource information on how to implement it? You can use pgcluster: http://pgcluster.projects.postgresql.org/ (I haven't tried it yet) Of course, you can install any clustering

Re: [GENERAL] Clustered PostgreSQL

2006-03-14 Thread Devrim GUNDUZ
Hi, On Tue, 14 Mar 2006, Thomas Hallgren wrote: If you're using JDBC, the C-JDBC (http://c-jdbc.objectweb.org/) might be a good option. Definitely. I've read some papers on C-JDBC 3 years ago, and was really satisfies with its features. Regards, -- The PostgreSQL Company - Command

Re: [GENERAL] Clustered PostgreSQL

2006-03-14 Thread Devrim GUNDUZ
Hi, On Tue, 2006-03-14 at 11:08 -0700, Brendan Duddridge wrote: Do you know if pgcluster will work with PostgreSQL 8.1.3? I haven't tested but as far as I can read from web page, 1.5.0rc1 works on 8.1.1 -- They now have rc7, and maybe it works on 8.1.3, but I don't know... Regards, -- The

[GENERAL] PostgreSQL New RPM Sets for FC/RH

2006-02-19 Thread Devrim GUNDUZ
- PostgreSQL New RPM Sets 2006-02-19 Versions: 8.1.3, 8.0.7, 7.4.12, 7.3.14 Set labels: 8.1.3-1PGDG, 8.0.7-1PGDG, 7.4.12-1PGDG, 7.3.14-1PGDG -

Re: [GENERAL] Minor Releases 7.3 thru 8.1 Available to Fix Security

2006-02-16 Thread Devrim GUNDUZ
Hi, On Thu, 2006-02-16 at 09:58 -0700, Nels Lindquist wrote: Just wondering how long before binaries for RHEL3 show up? The RHEL4 binaries are available, and there were RHEL3 binaries for 8.1.2. Sorry for the delay in building RHEL3 RPMs. I just built RPMs for RHEL 3 and FC3. They are on

Re: [GENERAL] Database Comparison tool?

2006-02-09 Thread Devrim GUNDUZ
Hi, On Wed, 2006-02-08 at 18:22 +, Nicholas Walker wrote: Are there any tools that can compare a database schema, and produce sql of the changes from one version to the next. http://www.sqlmanager.net/en/products/postgresql/dbcomparer

Re: [GENERAL] [HACKERS] New project launched : PostgreSQL GUI Installer for

2006-01-31 Thread Devrim GUNDUZ
Hi, On Tue, 2006-01-31 at 08:34 +0100, Tino Wildenhain wrote: http://pgfoundry.org/projects/pgnixinstaller/ We are actively looking for developers for the project. Please drop me an e-mail if you want to join this project. We will use Python, so you need to be a Python guy to join

Re: [GENERAL] New project launched : PostgreSQL GUI Installer for

2006-01-31 Thread Devrim GUNDUZ
Hi, On Tue, 2006-01-31 at 08:36 +0100, Tino Wildenhain wrote: Are you going to work with the underlying system's package manager, or put everything in /usr/local? We'll work with the package manager -- I'm an RPM guy ;) RPM isnt the only packaging system out there ;) I used RPM as

Re: [GENERAL] [HACKERS] New project launched : PostgreSQL GUI

2006-01-31 Thread Devrim GUNDUZ
Hi, On Mon, 2006-01-30 at 22:45 -0500, Vivek Khera wrote: However none of them are PostgreSQL Installers, none of them has the ability to customize the packages and none of them has the ability to install the community packages, etc. :) You need to take a sniff over at the FreeBSD

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

2006-01-31 Thread Devrim GUNDUZ
Hi, On Mon, 2006-01-30 at 21:27 -0500, Jonah H. Harris wrote: I had to deal with an installer written in python and several in Java... IMHO, Java would be a better language for this and you could build off some nice OSS installers that already exist (such as IzPack). Just my 2 cents :)

[GENERAL] New project launched : PostgreSQL GUI Installer for Linux/Unix systems

2006-01-30 Thread Devrim GUNDUZ
Hi, As you know, many databases that run on Linux / Unix systems have a GUI installer which make installation easier and more attractive for some people. Our Windows Installer is very attractive, for example. Now, I and Burcu Guzel, who is a Senior Programmer, decided to launch a new project:

Re: [GENERAL] New project launched : PostgreSQL GUI Installer for

2006-01-30 Thread Devrim GUNDUZ
Hi, On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote: We are actively looking for developers for the project. Please drop me an e-mail if you want to join this project. We will use Python, so you need to be a Python guy to join the project. We are in planning phase, if you join us

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

2006-01-30 Thread Devrim GUNDUZ
Hi, On Mon, 2006-01-30 at 20:27 -0500, Andrew Dunstan wrote: OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI RPM interface for the repositories. So our installer will help them a lot. Also, our installer will have an option to download and install the prebuilt

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

2006-01-30 Thread Devrim GUNDUZ
Hi, On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote: Certainly you can install pre-built binaries without a compiler, and let the user choose database location, autovacuum settings and stuff like that. That's another good point. We can adjust many settings before installing.

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

2006-01-30 Thread Devrim GUNDUZ
Hi, On Mon, 2006-01-30 at 21:34 -0400, Marc G. Fournier wrote: OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI RPM interface for the repositories. So our installer will help them a lot. Also, our installer will have an option to download and install the prebuilt

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

2006-01-30 Thread Devrim GUNDUZ
Hi, On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote: You can install, but what if you need different configure options than the package provides? This means a rebuild of the package. Instead, we will build and install that package via the installer. That's actually a pretty cool

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

2006-01-30 Thread Devrim GUNDUZ
Hi, On Mon, 2006-01-30 at 22:04 -0400, Marc G. Fournier wrote: BTW, gcc is not installed on by default AFAIR. Wow, how do you update the kernel each week? :) More seriously, I know under FreeBSD, one of the first things that gets done after installing is to customize the kernel to get

Re: [GENERAL] Please, help! About database cluster and adding to

2006-01-25 Thread Devrim GUNDUZ
Hi, On Wed, 2006-01-25 at 12:40 +0300, Sergey Karin wrote: We create database cluster (via initdb) on some disk. Then we create and use a database that can be very large. In some moment the database occupy all disk space allicated to cluster. The question is: are there any abilities in

  1   2   3   >