-I/usr/include/postgresql/9.1/server ...
>
> I want to build for 9.2. How can I do this?
Edit makefile, and find this line:
PG_CONFIG := pg_config
You need to use 9.2 pg_config to build plr against 9.2.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.
:
> pgdg-centos91-9.1-4.noarch.rpm
> and since there's no 9.1.9 upgrade for CentOS(RHEL & Fedora), I'm going to
> upgrade to 9.1.9 like this:
> rpm -U postgresql91-server-9.1.9-1PGDG.rhel6.x86_64.rpm Sound good?
yum install postgresql91-server will do the trick.
Regar
/yum.postgresql.org/9.1/redhat/rhel-6-x86_64/repoview/postgresql91-server.html
9.1.9 .
-HTH
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gund
resql91*
That will update your packages. FWIW, CentOS 6 9.1 RPMs are here:
http://yum.postgresql.org/9.1/redhat/rhel-6-x86_64/
and
http://yum.postgresql.org/9.1/redhat/rhel-6-i386/
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Dan
sql" package. Is it possible to
>upgrade "postgresql84" using the RPM from "postgresql" ?
>
>Regards,
>John
>
>From: Devrim Gündüz [mailto:dev...@gunduz.org]
>Sent: Thursday, April 4, 2013 11:42 AM
>To: John Reeve; pgsql-admin@postgresql.org
>Subjec
4-server-5 repo not current?
>
>Or do I have to do a complete reinstall from "postgresql84" packages to
>"postgresql" packages in order to use a new repo, such as
>yum.postgresql.org?
>
>Any advice on how to go about this is greatly appreciated.
>
>Thanks!
>John
--
Devrim Gündüz
edhat/9.1/postgresql/EL-6/postgresql-9.1.spec#L306
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twit
hey
start at the same time?
I'd start with setting ordered=1 and restricted=0 in cluster.conf. Also
make sure that you have disabled both postgresql init scripts to start
on boot.
Let me know if these don't help.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ Enterprise
these processes?
IIRC check_postgres (http://bucardo.org/wiki/Check_postgres) has a
monitoring stuff for this.
-HTH.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL
they will
help you a lot. Luci is the web interface for configuring cluster, ricci
is the agent on each node.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~Postgr
kB 00:00
>
>
> Public key for wxBase-2.8.12-1.el5.i386.rpm is not installed
> Trying to just install wxbase has the same outcome
It was my mistake. Just resigned the packages. Please run
yum makecache
first, and then try installing pgadmin3 again.
Sorry for the inconvenience.
Re
e compatible with
the previous versions, so receving xlogs from older releases will be
supported. Upgrade standby first, and then the master server"
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat C
cepting
>connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
You need to pass -p parameter to psql:
$ bin/psql -p
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified
Hi,
On Thu, 2012-09-13 at 01:30 -0700, johnkn63 wrote:
> The phpPgAdmin message is "login failed" if I change the same user to
> a superuser they can login.
Did you check pg_hba.conf? What's in the PostgreSQL logs?
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer
Forwarding to the list, since the first one did not go through.
Forwarded Message
> From: Devrim GÜNDÜZ
> To: Jonathan Pool
> Cc: pgsql-admin@postgresql.org, Susan Colowick
> Subject: Re: [ADMIN] symbol lookup error: /usr/pgsql-9.1/bin/pg_ctl:
> undefined
I think I finally managed to find a solution for this. It is on the
testing phase now, expect to get the new packages soon.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: dev
t the instructions told me to download a file and then
> issue a command that doesn't reference the downloaded file.
That is my mistake. I changed the filenames a few months before, but it
seems I forgot to update website:
http://yum.postgresql.org/repopackages.php
This is now up2date.
Regards
lse (like Red Hat Cluster Suite) for that.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twit
On Mon, 2012-04-16 at 16:27 -0700, ЇЯЅHAÐ wrote:
>
>
> We are trying to migrate from Postgres to Oracle,
Hmm.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~Postg
Hi,
On Sat, 2012-04-07 at 21:35 -0700, Dave Johansen wrote:
> Yes, I think that I'll be using 9.0, but I also noticed that 8.4
> doesn't have them either.
I pushed them, too.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
Post
sing a difference version?
While on it, I also updated libpqxx to 4.0 for PostgreSQL 9.1+.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.
7;t need to install -devel
package for pg_config.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org T
erver as "active" server, like I told in the
25th slide of the presentation that I just in the previous email.
So, RHCS and SR/HS are not competitive to each other. We have installed
them in parallel several times, like to 3 servers.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @
ly, which is later ignored?
>
> or
>
> 2) Do I make it primary, then point its pgdata to the already existing
> data during install ?!?
See above.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consul
//www.gunduz.org/download.php?dlid=190
will give you ideas about setting up RHCS with PostgreSQL. I don't have
any doc for triggering failover with RHCS, though. Should be very
simple.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
Postgr
;t do a pg_dump on the standby db?
Both are correct. You need to use 9.0+ to be able to read from standby.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~Postgre
these packages are different from the packages you
install, in terms of file layouts. You may need to remove old packages
first, in case of a warning. If you have a data, please take backup.
Also, the new data directory is /var/lib/pgsql/9.0, instead
of /var/lib/pgsql.
Regards,
--
Devrim GÜNDÜZ
Pri
age:
> postgresql-contrib-9.0.0-1PGDG.el5.x86_64
> --> Finished Dependency Resolution
> Error: Package: postgresql-contrib-9.0.0-1PGDG.el5.x86_64 (pgdg90)
>Requires: libpython2.4.so.1.0()(64bit)
What is the output of
grep baseurl /etc/yum.repos.d/pgdg-9*
Regards,
--
ecovery in
the documentation.
> and same like oracle SQL Loader in postgresql.
We have pgloader:
http://pgfoundry.org/projects/pgloader
http://pgloader.projects.postgresql.org/
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışman
On Wed, 2011-09-21 at 15:29 +0200, Daniel Vázquez wrote:
>
> I read in Unaccent contrib module that's compatible with PostgresSQL
> 8.4 and 9.x
Too lazy to check the docs, but IIRC unaccent was added in 9.0.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ Ente
o PostgreSQL 9.0+, there is "hot
standby" option, which lets you run read-only queries on standby server.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~Pos
no longer need -devel packages on your prod
system. Yum will pick up all prerequisites automagically.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org
On Thu, 2011-08-18 at 17:06 +0530, Venkat Balaji wrote:
>
> I am getting the following error when trying to install PG-9.0.1 -
Why don't you use RPMs for that?
http://yum.pgrpms.org
(and please use 9.0.4)
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ Enterpr
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
>
> Anyone know of tools / options that will allow Oracle to PostgreSQL
> replication? or at least a real time feed or dblink?
EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
solution bundled.
Regards,
--
the tarballs also should exist on ftp.postgresql.org and its
mirrors, so you can download them from the mirrors, too, like:
ftp://ftp.linux.org.tr/postgresql/projects/pgFoundry/pgpool/
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danış
On Tue, 2011-04-19 at 12:38 +0530, Muruganand Karthikeyan wrote:
>
> Yes it has to be version 8.4.5, since we have already upgraded at an
> organizational level to 8.4.4, so the next obvious upgrade would be to
> 8.4.5:)
This is not the right path, IMHO.
--
Devrim GÜNDÜZ
Princ
Hi,
On Wed, 2011-04-13 at 23:23 +0530, raghu ram wrote:
> Is there any limitations to configure streaming replication between
> different operating systems i.e solaris 64 bit to RHEL 64 bit.
It won't work.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ Enterpr
l (it is giving fail).
>
> What could be the reason for the fail to start the postgresql?
Please see
/var/lib/pgsql/pgstartup.log
and tell us what's inside that log file.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Dan
t listens to localhost. See listen_addresses parameter.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org T
On Thu, 2011-03-31 at 05:52 -0700, bilal ghayyad wrote:
> And how to make it started automatically when the machine booted?
> Without need to type the command to start manuall?
chkconfig postgresql on
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprise
On Thu, 2011-03-31 at 04:37 -0700, bilal ghayyad wrote:
> Mine is Fedora 10, how it will be?
I already wrote what you need to do.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: dev
nding on the version) would
work.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http:/
.d/"? I couldn't find any service file in the
> installation source directory. I'm installing PostgreSQL from source
> code. I wonder why postgresql service file is not available as part
> of the installation source?
See contrib/start-scripts/linux . Init script is
stgresql server
> process.
You are probably hitting kernel.shmmax value in /etc/sysctl.conf .
But... which parameter are you trying to set to 63GB?
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified
No.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
a dump/restore, what are the recommended ways/steps
> involved in upgrading PostgreSQL to latest version for minor releases?
? Did you read the paragraph above?
Install latest version, and restart postmaster.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterp
[FAILED]
Could you please take a look at /var/lib/pgsql/pgstartup.log (assuming
that this is an RPM installation)?
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~Po
#x27;. Stop.
>
> May I know how can I fix this problem? What should I do,
You need to install postgresql-server-dev (or whatever the package name
is) to install pgxs.
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Commun
It even won't work between different Linux flavors.
You need to use a replication solution, like Slony.
Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.o
Red Hat Linux 5.5. environment.
http://yum.pgrpms.org/howtoyum.php
You can use this repository, as guided, and then install postgresql 9.0:
http://people.planetpostgresql.org/devrim/index.php?/archives/48-What-is-new-in-PostgreSQL-9.0-RPMs.html
Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://ww
tgresql-libs-8.1.22-1.el5_5.1.i386
> installed. I've installed postgresql from the pgdg rpm.
The message says "You have 8.3, which is newer than 8.1". It does not
say that you have 8.1.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Postgr
0/redhat/rhel-6-x86_64/repoview/letter_w.group.html
You may want to use that repo directly, so that yum will resolve and
download dependencies for you. Or, you can download and install files
manually.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified EngineerI
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 digital
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 you
On Sun, 2010-12-05 at 17:49 -0500, Tom Lane wrote:
> Maybe you need to lobby the Debian folks to revert to a less broken
> version of libreadline. It surely has got no business exporting
> either of those symbols.
Could it be libreadline5 vs libreadline 6?
--
Devrim GÜNDÜZ
PostgreSQL
The ones starting with postgresql90-*-9.0.1-* )
and install them manually as written in the comment above. That should
be enough.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~Postgre
f this is a new table or any changes have
> been made to this table.
>
> ERROR: column t.tgisconstraint does not exist at character 387
Could it be a non-9.0 aware client software?
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repositor
ystems to run > 1 pg versions with
> packages, but never rpm based. Especially not Centos or RHEL. Has
> Fedora / yum started aachieved that?
http://people.planetpostgresql.org/devrim/index.php?/archives/48-What-is-new-in-PostgreSQL-9.0-RPMs.html
Regards,
--
Devrim GÜNDÜZ
PostgreSQL D
ocation without disturbing the old one.
9.0 can be installed in parallel with yum, however still a dump/restore
or replication/failover type thing is needed, since 8.1 is not supported
by pg_upgrade.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Reposit
On Tue, 2010-10-05 at 11:03 +0530, Vishnu S. wrote:
>
> Yes. I have written a script file like the following.
>
> include ;
> init cluster (id=1, comment='hostname=10.2.26.53 port=5432');
It does not give me the $CLUSTER_NAME information.
--
Devrim GÜNDÜZ
PostgreSQL
On Tue, 2010-10-05 at 10:19 +0530, Vishnu S. wrote:
> LOG: unexpected EOF on client connection
> ERROR: schema "_testcluster" does not exist at character 30
Did you run slonik_init_cluster?
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQ
u change the port number in postgresql.conf? Specifying
--with-pgport only embeds port number to binaries, not to
postgresql.conf.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, d
On Wed, 2010-09-29 at 18:26 +0530, Anuj Pankaj wrote:
>
> I modified listen_addresses = '*' in Postgresql.conf and however If I
> try to access postgres through pgAdmin III. I am sticking with an
> exception.
Did you restart PostgreSQL after the change?
--
Devrim GÜNDÜ
On Mon, 2010-09-27 at 15:41 +0530, Vishnu S. wrote:
>
> Please tell me, from where I will get the complete Slony-I
> iinstallation package, compatible with PostgreSQL 8.4.
Which platform is this? How did you install PostgreSQL?
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant
On Wed, 2010-09-15 at 15:09 +0530, Anuj Pankaj wrote:
>
> Here I am unable to rum rpm -e to uninstall the
> postgres
> 8.1.4.
What is the error message that you are getting?
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repo
be good for you.
--
Devrim GÜNDÜZ
PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To m
See pg_stat_user_tables table.
--
Devrim GÜNDÜZ
PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
18.Ağu.2010 tarihinde 18:30 saatinde, Anj Adu
them
goes down.
You can also use Slony-I or Londiste, too.
Please note that 9.0 will ship with major features for this.
-HTH.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.
On Mon, 2010-06-21 at 16:22 +0530, Vishnu S. wrote:
> I have disabled the WAL log ,
What?
--
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
h
install pg_standby manually.
I think the good way is (2).
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
On Tue, 2010-05-18 at 17:56 +0800, Narasimha Murthy-VRFX87 wrote:
> My Query: I want to run autovacuum daemon everyday at 5 am.
That is not "auto"vacuum. What you want is manual vacuum.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Rep
1. turn off the standby config in primary
> 2. upgrade primary
> 3. rebuild standby
You need to upgrade standby first, restart it. Then, upgrade master and
restart it. No need to turn off standby config.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Po
;t vacuumed for a long time, it may
be the best to dump/restore the database, and then apply regular
maintenance:
http://www.postgresql.org/docs/current/static/maintenance.html
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository:
updating tar
version and then try again.
--
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
si
n functionality. However, probably pg_migrator
will be available for 9.0, too.
To sum up: 9.0 has big features, like replication, etc. IMHO it won't be
production ready for a few months after it is released (yeah, I'm a bit
optimistic here). So you should stick to 8.4 for now.
--
On Mon, 2010-04-12 at 13:43 +0200, Dennis Thrysøe wrote:
>
> "the database system is starting up" in the postgres log while system
> is running in archive recovery mode (warm standby).
That is ok. pg_standby always waits for the next WAL , so it is always
in startup mode
On Wed, 2010-04-07 at 16:01 +0200, Robert Gravsjö wrote:
> > Do you suggest having the images in a different database by itself?
>
> I'd suggest storing meta information in PostgreSQL and the images in
> the filesystem.
Is this transaction safe?
--
Devrim GÜNDÜZ
ou'll see the query
there .
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
signat
. Another way is
adding /usr/lib/postgresql/8.4/bin to $PATH.
--
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://tw
ter to
slave server as user postgres (or whatever). If you are sure that
nothing is wrong, feel free to delete the related entry in
~/ssh/known_hosts file, and ssh to the slave server manually to test.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repo
On Mon, 2010-03-15 at 19:25 -0700, David Jantzen wrote:
> We'll look at upgrading to 8.3.9 from an RPM.
FWIW 8.3.10 was released today.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~Postgr
FWIW, timestamps are rewritten in recent pgpool versions to avoid such
issues.
However, similar problems exist for serial, etc.
-HTH.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gu
ht
now.
Regards,
--
Devrim GÜNDÜZ, RHCE
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, 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
On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
>
>
> No idea if anyone is building RPMs for it
Of course I'm building ;)
We have pg_migrator 8.4.14 for RHEL/CentOS 4,5 and Fedora 12-i386.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gund
S repo.
https://projects.commandprompt.com/public/pgcore/repo/rpm/redhat/
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 Twitter: http://twitter.com/devrimgunduz
signature.
!?intdatetimes:%define intdatetimes 1}
to
%{!?intdatetimes:%define intdatetimes 0}
and build packages on your server. I don't have any interest to push
non-id packages to repository, unless my boss specifically asks me to do
so ;)
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://ww
ther you
compiled PostgreSQL or not.
Another way is extracting files from RPM using cpio, and pushing them to
related directories, but I don't recommend it.
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gu
nybody has good step by step doc for warm standby setup?
https://projects.commandprompt.com/public/pitrtools
This BSD-licensed software includes a nice document for setting up a
warm standby.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim
On Mon, 2009-11-16 at 16:59 -0800, Kasia Tuszynska wrote:
>
> On Linux
> -rpms do not install the xml type by default
You need to install postgresql-contrib package.
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~Postg
rror? (Specifying --nogpgcheck gets me around. Is this safe to do?)
It was an error on my side. Fixed. Thanks for the report.
You may need to run
yum makecache
before downloading signed package.
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devr
check it.
--
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
g if there is an easy global solution for this.
Until you fix your app, you can re-add these casts:
http://wiki.postgresql.org/images/d/d1/Pg83-implicit-casts.sql
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devri
On Mon, 2009-08-03 at 16:02 -0500, Plugge, Joe R. wrote:
> What version of Slony-I is "ok" to use with version 8.4.0, I am
> getting this error when trying to make against 8.4.0 on RHEL4:
I just tested building 1.2.17rc on RHEL4 -- it worked fine.
--
Devrim GÜNDÜZ, RHCE
Comma
PGDG RPMs on CentOS:
http://yum.pgsqlrpms.org/howtoyum.php
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
tgresql.org/pgsql-hackers/2008-09/msg00208.php
--
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
written ;)
Anyway, we are talking about an issue which should never ever happen, if
docs were read. I announced -devel RPMs lots of times, and each one
included a notice for dump/reload action.
BTW, I was intending to introduce multiple version installation with
RPMs with 8.4, but it is already push
On Tue, 2009-06-16 at 10:10 +0300, Devrim GÜNDÜZ wrote:
> As Scoot wrote
Scott, sorry for the typo.
--
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.
as the same by PostgreSQL developers.
I've been pushing RPMS for testers only, so please be careful when you
use any development PG packages next time.
Sincerely,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.g
o exist:
http://yum.pgsqlrpms.org/srpms/8.4/redhat/rhel-5-i386/postgresql-8.4devel_20090310-1PGDG.rhel5.src.rpm
You can build them in your platform, and as Scott said, install them,
backup old data and then update to RC1.
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
dev
On Mon, 2009-06-01 at 09:29 -0400, Justin Carrera wrote:
> Does anyone have the postgres library for ruby?
http://rubyforge.org/projects/ruby-pg
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org
1 - 100 of 140 matches
Mail list logo
