> On Apr 30, 2019, at 07:16, Adrian Klaver wrote:
>
>> On 4/30/19 2:02 AM, Lewis Shobbrook wrote:
>> Hi Guys,
>> With the repo changes associated with the April 17 changes,
>> https://pgstef.github.io/2019/04/17/one_rpm_to_rule_them_all.html
>> It is evident that support for amazon linux has
On Wed, 8 May 2019 at 07:19, Tim Cross wrote:
>
> I would find out if the IT team who will maintain the system are running
> a specific Linux distribution, such as RHEL and just go with the PG
> version that is on that distribution.
>
Bear in mind, depending on the OS, the default version
No, I'm asking about the application.
On 5/7/19 3:51 PM, David Gauthier wrote:
>>Home-rolled application, or third party?
Are you asking about how they do VMs ?
They already provide PG v9.6.7 , so I gather they're not averse to
supporting PG DBs.
On Tue, May 7, 2019 at 4:05 PM Ron
I would find out if the IT team who will maintain the system are running
a specific Linux distribution, such as RHEL and just go with the PG
version that is on that distribution.
Large corp rarely have sufficient IT resources. Unless you specifically
need a particular PG version (which does not
>>Home-rolled application, or third party?
Are you asking about how they do VMs ?
They already provide PG v9.6.7 , so I gather they're not averse to
supporting PG DBs.
On Tue, May 7, 2019 at 4:05 PM Ron wrote:
> On 5/7/19 1:52 PM, David Gauthier wrote:
>
> Hi:
>
> I'm going to be requesting a
On 5/7/19 1:52 PM, David Gauthier wrote:
Hi:
I'm going to be requesting a PG instance supported by an IT team in a
large corp. They will be creating the server as a VM. We will be loading
the DB using scripts (perl/dbi) on linux, possibly using bulk loading
techniques if that's required.
I have not used SS for spatial data, but I don't have a Postgres database
without Postgis installed. The OSGEO ecosystem and synergies with other FOSS
GIS tools is fantastic.
And it does not stop with the Postgis extension. For time series data (anything
from fleet management to sensor data)
David Gauthier schrieb am 07.05.2019 um 20:52:
I need to pick a PG version in my request. I want something that
will be stable and reliable while, of course, being able to perform
well. What would be a good choice for PG version?
There is no reason to not choose the latest version.
So I
On 5/7/19 11:52 AM, David Gauthier wrote:
Hi:
I'm going to be requesting a PG instance supported by an IT team in a
large corp. They will be creating the server as a VM. We will be
loading the DB using scripts (perl/dbi) on linux, possibly using bulk
loading techniques if that's required.
Hi:
I'm going to be requesting a PG instance supported by an IT team in a large
corp. They will be creating the server as a VM. We will be loading the DB
using scripts (perl/dbi) on linux, possibly using bulk loading techniques
if that's required. Queries will come from both linux and the web,
You can fix the problem with this query:
SELECT setval('chinese_price_infos_id_seq', sq.val) from ( SELECT
MAX(id) as val FROM chinese_price_infos ) sq;
But you have to search in your application because in some point the
app are inserting the id column instead of leave this task to the DB.
If
On Tue, May 7, 2019 at 3:12 PM Myles Miller wrote:
> No, the function is returning just one letter, either 'A' or 'B', not
> multiple values.
Your random function is being evaluated ONCE FOR EACH ROW.
i.e, it's doing something like:
select y from
( SELECT y, chr(round(random())::int + 65)
> Next month I'll be making a presentation about Postgres to a SQL
> Server crowd in L.A. at their SQL Saturday event.
>
> I was wondering if anyone has any tips that are specific for SQL
> Server users? Best features? Known issues? Common rebuttals?
PosgreSQL is more than a "database",
> > # SELECT y FROM x WHERE y = chr(round(random())::int + 65);
> > y
> > ---
> > A
> > B
> > (2 rows)
> Here you got a random value in the lower range of 0..1 for the record with
> value ‘A’, so that’s a match, and one in the higher range for value ‘B’, a
> match again, so you get 2 rows.
No,
On Tue, May 07, 2019 at 12:17:12PM +, Daniel Perrett wrote:
> The WHERE expression (and therefore the random function) is being evaluated
> once per row, not once per query.
> If you run this query a few times, you will see the problem:
> SELECT y, chr(round(random())::int + 65) FROM (SELECT
> On 7 May 2019, at 13:53, Myles Miller wrote:
>
> PROBLEM:
> Strings or characters generated by any random function (including pg_crypto
> gen_random_bytes) are matching a string/char index in surprising ways.
I fail to see anything surprising in your examples.
> Reduced down to its
I think getting postgres to work with VIP (assuming virtual IP) is not a
postgres issue, but rather a server/network issue.
Redhat seems to have some documentation on enabling nonlocal binding, which may
be useful for you:
Thanks Chris!
Our Network Admin have the instruction to bind a VIP, but regarding Postgresql
what is needed to be done?
We don't have to change any parameter?
How about "listen_addresses = ', ' # what
IP address(es) to listen on;" or we simply use "*"?
-Original Message-
Good day,
Would you be able to help direct me to instruction or implementation step to
bind a VIP to a Postgresql instance?
I did research and understand that Postgresql does support binding of VIP, but
I can't find documentation to implement the solution.
Any feedback is greatly appreciated.
PROBLEM:
Strings or characters generated by any random function (including pg_crypto
gen_random_bytes) are matching a string/char index in surprising ways.
Reduced down to its simplest example:
-- use random 0 or 1, plus 65, to get 'A' or 'B'
# SELECT chr(round(random())::int + 65);
chr
-
On 5/7/19 9:25 AM, Rashmi V Bharadwaj wrote:
Hi,
That query will only give the PostgreSQL database server's IP address
right? That is true while we do a remote access to the non-cloud
database from another machine also.
I want to know if there is anything specific that can be used to
Hi,Is there a SQL query or a database parameter setting that I can use from an external application to determine if the PostgreSQL database is on cloud (like on Amazon RDS or IBM cloud) or on a non-cloud on-prem environment?Thanks,Rashmi
Igal Sapir schrieb am 07.05.2019 um 07:58:
> GIS is a good feature but it's a niche feature, so while I'll mention
> it with extensions I am looking for more general-purpose comparisons
> and areas where Postgres is as-good or better than SQL Server.
I have a comparison of various DBMS products
For me, another very useful featureset in Postgres is the extensive set of
datatypes and functions, including the strong JSONB support.
Also, i would focus on the widespread support of Postgresql by services
such as Amazon, Google, Heroku,
Another place to focus on would be the really extensive
24 matches
Mail list logo
