Hi,
I'm looking for old postgres rpm, like
postgresql93-server-9.3.6-1PGDG.rhel6.x86_64.rpm
(one of our software is "certified" with this minor version ...)
Thanks in advance
Etienne
Hi,
On Mon, 2015-09-21 at 09:31 +0200, Etienne Champetier wrote:
>
> I'm looking for old postgres rpm, like
> postgresql93-server-9.3.6-1PGDG.rhel6.x86_64.rpm
>
> (one of our software is "certified" with this minor version ...)
We don't keep those RPMS, but you can build the RPMs by yourself.
Hello,
I have a float array holding geo location information.
geoloc
---
{5.3443133704554,100.29457569122}
{5.3885574294704,100.29601335526}
{3.1654978750403,101.60915851593}
{5.3766154817748,100.31472444534}
{3.1545014704258,101.70036971569}
(5
On 21/09/15 11:55, Alex Magnum wrote:
> Hello,
>
> I have a float array holding geo location information.
>
> geoloc
> ---
> {5.3443133704554,100.29457569122}
> {5.3885574294704,100.29601335526}
> {3.1654978750403,101.60915851593}
> {5.376615481774
Alex Magnum wrote:
> Hello,
>
> I have a float array holding geo location information.
>
> geoloc
> ---
> {5.3443133704554,100.29457569122}
> {5.3885574294704,100.29601335526}
> {3.1654978750403,101.60915851593}
> {5.3766154817748,100.3147244453
On Mon, Sep 21, 2015 at 11:55:23AM +0200, Alex Magnum wrote:
> Hello,
>
> I have a float array holding geo location information.
>
> geoloc
> ---
> {5.3443133704554,100.29457569122}
> {5.3885574294704,100.29601335526}
> {3.1654978750403,101.6091585
hubert depesz lubaczewski wrote:
> > Is there an easy way to round all values to 4 decimals.
>
> Sure:
>
> (depesz@[local]:5960) 12:15:46 [depesz]
> $ select geoloc::numeric(8,4)[] from alex;
> geoloc
> ---
> {5.3443,100.2946}
Nice!
Andreas
--
Really, I'm not out to
>> Sure:
>>
>> (depesz@[local]:5960) 12:15:46 [depesz]
>> $ select geoloc::numeric(8,4)[] from alex;
>> geoloc
>> ---
>> {5.3443,100.2946}
>
> Nice!
Indeed :)
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your s
On 9/21/2015 12:31 AM, Etienne Champetier wrote:
I'm looking for old postgres rpm, like
postgresql93-server-9.3.6-1PGDG.rhel6.x86_64.rpm
(one of our software is "certified" with this minor version ...)
I cringe when I see requirements like this. did they also 'certify'
this applicaiton to
On Mon, Sep 21, 2015 at 10:46 AM, John R Pierce wrote:
> On 9/21/2015 12:31 AM, Etienne Champetier wrote:
>
>> I'm looking for old postgres rpm, like
>> postgresql93-server-9.3.6-1PGDG.rhel6.x86_64.rpm
>>
>> (one of our software is "certified" with this minor version ...)
>>
>
> I cringe when I s
Hi,
2015-09-21 17:46 GMT+02:00 John R Pierce :
> On 9/21/2015 12:31 AM, Etienne Champetier wrote:
>
>> I'm looking for old postgres rpm, like
>> postgresql93-server-9.3.6-1PGDG.rhel6.x86_64.rpm
>>
>> (one of our software is "certified" with this minor version ...)
>>
>
> I cringe when I see requi
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ?
Sent: Thursday, September 17, 2015 9:11 AM
To: pgsql-general@postgresql.org
Cc: Антон Бушмелев
Subject: [GENERAL] @ operator
Hello, google nothing for @ operator =(, what does thi
Thanks for reply, it is clear now =)
On 09/17/2015 08:34 PM, David G. Johnston wrote:
On Thursday, September 17, 2015, David G. Johnston
mailto:david.g.johns...@gmail.com>> wrote:
On Thursday, September 17, 2015, Антон Бушмелев
> wrote:
Hello, google nothing for @ operator =(
I have one database and two schemas in that public,preview and role preview
automatically i want to connect preview schema with preview role.
set search_path to preview.
show search_path;
..
preview.
when disconnect and connect database it's showing $user$:public schema not
showing preview.
wha
I have written a number of functions in C that return BYTEA type. I have
compiled and run on both Windows and Linux, 32-bit and 64-bit, PostgreSQL
versions 9.3 and 9.4.
My functions return BYTEA data to the caller. The problem is that memory usage
grows until there is no memory left on the host
2015-09-21 4:31 GMT+02:00 John Leiseboer :
> I have written a number of functions in C that return BYTEA type. I have
> compiled and run on both Windows and Linux, 32-bit and 64-bit, PostgreSQL
> versions 9.3 and 9.4.
>
> My functions return BYTEA data to the caller. The problem is that memory
> u
Hi,
I have two questions about PostgreSQL repositories:
1. rsync
Would it be possible to have PostgreSQL 9.5 in the rsync-repo?
2. yum repo for Fedora 23
Is it possible to have fedora 23-repo for PostgreSQL? Especially 9.4 and 9.5.
*** Is there anything I can do, to help with this?
--
Med v
You cannot directly "connect" one schema with another,
but you can set the default to have both in the search_path.
Uncomment the #search_path parameter in Postgresql.conf
and change it to
search_path = 'preview, role,public,"$user",public'
The make sure you do:
sudo su - postgres
pg_ctl reload [-
On 9/21/2015 11:52 AM, Melvin Davidson wrote:
You cannot directly "connect" one schema with another,
but you can set the default to have both in the search_path.
Uncomment the #search_path parameter in Postgresql.conf
and change it to
search_path = 'preview, role,public,"$user",public'
the abo
John R Pierce wrote:
> better would be to...
>
> ALTER ROLE username SET SEARCH_PATH='preview,"$user", public';
> or
> ALTER DATABASE dbname SET...;
>
> and then this change just applies to that named role or database...
(or
ALTER ROLE username IN DATABASE dbname SET ..
which applies
You are correct John, but in this case, he stated only one (1) database. So
changing the search path in .postgresql.conf simplifies things for all
users.
However, should he create additional databases later on, then yes, your
solution would be better.
On Mon, Sep 21, 2015 at 3:08 PM, Alvaro Herre
I have searched the mailing list archives as well as the
internet at large but haven't been able to find a _streaming_
version of md5 hashing for large objects. The closest thing I
found is this thread
http://www.postgresql.org/message-id/5d0f60990704081003p615530acx86257a70bff33...@mail.
On 09/21/2015 05:46 AM, Kjetil Nygård wrote:
Hi,
I have two questions about PostgreSQL repositories:
1. rsync
Would it be possible to have PostgreSQL 9.5 in the rsync-repo?
I am not understanding what you mean above.
In other words not sure what Postgres has to do with rsync?
2. yum repo
While awaiting the awesomeness of the upcoming "skip locked" feature in 9.5
I need to handle a work queue.
Does anyone see any glaring issues or subtle nuances with the basic method
below which combines CTEs with queue-handling methods posted by depesz, on
the PG wiki and elsewhere.
Note that it
On 9/21/2015 5:46 AM, Kjetil Nygård wrote:
2. yum repo for Fedora 23
Is it possible to have fedora 23-repo for PostgreSQL? Especially 9.4
and 9.5.
I thought F23 starts beta next week?
it appears 9.4.4 is included in the F23 base repository.
postgres 9.5 is itself still in beta.
--
john r pi
Hi,
Just want to let everybody knows
So, I found out this morning what went wrong.
For some reason, there were some bad wal log files in pg_xlog. I believe
that they got generated during the backup last Monday, but I don't know
why. I speculate that may be the wal_keep_segments was not set high
Hi,
On Mon, 2015-09-21 at 12:46 +, Kjetil Nygård wrote:
> 1. rsync
> Would it be possible to have PostgreSQL 9.5 in the rsync-repo?
Emailed PostgreSQL.org sysadmins, and I'll let you know when that is
done.
> 2. yum repo for Fedora 23
> Is it possible to have fedora 23-repo for PostgreSQL
Hi,
On Mon, 2015-09-21 at 15:46 -0700, Adrian Klaver wrote:
> In other words not sure what Postgres has to do with rsync?
I think OP refers to the YUM repo.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat
28 matches
Mail list logo
