Le sam. 23 nov. 2019 03:24, Martin Mueller
a écrit :
> I've moved happily from MySQL to Postgres but miss one really good
> feature of MYSQL: the table of tables that let you use SQL queries to find
> out metadata about your table. Thus looking at the table of tables and
> sorting it by last cha
I've moved happily from MySQL to Postgres but miss one really good feature of
MYSQL: the table of tables that let you use SQL queries to find out metadata
about your table. Thus looking at the table of tables and sorting it by last
change, lets you quickly look at the most recently modified tab
On 11/22/19 3:52 PM, stan wrote:
A while back I ran into problems caused by security fix related to the
search path. I wound up adding a line to. for instance, this function:
REATE FUNCTION
work_hours
(
start_date date,
end_date date
)
RETURNS decimal(10,4) stable
language sql as $
On 11/22/19 3:52 PM, stan wrote:
A while back I ran into problems caused by security fix related to the
search path. I wound up adding a line to. for instance, this function:
REATE FUNCTION
work_hours
(
start_date date,
end_date date
)
RETURNS decimal(10,4) stable
language sql as $
A while back I ran into problems caused by security fix related to the
search path. I wound up adding a line to. for instance, this function:
REATE FUNCTION
work_hours
(
start_date date,
end_date date
)
RETURNS decimal(10,4) stable
language sql as $$
/* workaround for secuirt
On 11/22/19 2:05 PM, Rémi Cura wrote:
Hello dear List,
I'm currently wondering about how to streamline the normalization of a
new table.
I often have to import messy CSV files into the database, and making
clean normalized version of these takes me a lot of time (think dozens
of columns and
Hello dear List,
I'm currently wondering about how to streamline the normalization of a new
table.
I often have to import messy CSV files into the database, and making clean
normalized version of these takes me a lot of time (think dozens of columns
and millions of rows).
I wrote some code to aut
On Fri, Nov 22, 2019 at 03:10:42PM +0100, Guillaume Lelarge wrote:
> First, please reply to the list, not me specifically.
>
> Le ven. 22 nov. 2019 ?? 14:51, stan a ??crit :
>
> > On Fri, Nov 22, 2019 at 01:58:11PM +0100, Guillaume Lelarge wrote:
> > > Hi,
> > >
> > > Le ven. 22 nov. 2019 ?? 1
I try to avoid DISTINCT and use GROUP BY when feasible, as well as avoiding
OR condition. If you combined anon1 and anon2 with UNION ALL, and did
(inner) join instead of left, or even moved all of that to EXISTS, perhaps
that gives you better consistent performance. Something like this-
SELECT co
On 11/22/19 8:27 AM, Jason L. Amerson wrote:
When I run pg_lsclusters, I get the following:
Ver Cluster Port Status OwnerData directory
9.4 main5432 down postgres /var/lib/postgresql/9.4/main
Log file
/var/log/postgresql/postgresql-9.4-main.log
When I run select version();, I get t
When I run pg_lsclusters, I get the following:
Ver Cluster Port Status OwnerData directory
9.4 main5432 down postgres /var/lib/postgresql/9.4/main
Log file
/var/log/postgresql/postgresql-9.4-main.log
When I run select version();, I get the following:
version
On 11/22/19 5:49 AM, Jason L. Amerson wrote:
I am start/stopping the server by using sudo service postgresql start/stop/restart/status. When I run any of these commands, I do not get anything. No confirmation, except for
Where did the postgresql file in /etc/init.d/ come from?
Does it have som
On 11/22/19 6:32 AM, aleksey ksenzov wrote:
Hi team.
Latest time we faced several issues which wouldn't arise provided we
have possibility to use constants in foreign key constraints.
brief example where it would be helpful:
table_a
( id uuid,
parent_id uuid,
is_deleted boolean
)
having possib
Hi team.
Latest time we faced several issues which wouldn't arise provided we have
possibility to use constants in foreign key constraints.
brief example where it would be helpful:
table_a
( id uuid,
parent_id uuid,
is_deleted boolean
)
having possibility of FK (parent_id, false) to (id, is_delete
On 11/22/19 5:40 AM, Jason L. Amerson wrote:
Adrian,
I originally did install PostgreSQL 12 from the repository. Then I removed it and decided to do it from source. I do have two postgresql.conf files and two pg_hba.conf files in
Well from your previous post "/etc/postgresql/9.4/main." That w
First, please reply to the list, not me specifically.
Le ven. 22 nov. 2019 à 14:51, stan a écrit :
> On Fri, Nov 22, 2019 at 01:58:11PM +0100, Guillaume Lelarge wrote:
> > Hi,
> >
> > Le ven. 22 nov. 2019 ?? 13:51, stan a ??crit :
> >
> > > I am trting to do something, and it ias not working as
I am start/stopping the server by using sudo service postgresql
start/stop/restart/status. When I run any of these commands, I do not get
anything. No confirmation, except for the status, it does show the server is
running. But otherwise, all I see is that it just goes to a new line with no
con
Adrian,
I originally did install PostgreSQL 12 from the repository. Then I removed it
and decided to do it from source. I do have two postgresql.conf files and two
pg_hba.conf files in two different locations. I guess I need to know which one
to keep. When I enter SHOW config_file;, I get the l
We would like to check the Postgres SYNC streaming replication status with
Nagios using the same query on all servers (master + standby) and versions
(9.6, 10, 12) for simplicity.
I came up with the following query which should return any apply lag in seconds.
select coalesce(replay_delay, 0)
Hi,
Le ven. 22 nov. 2019 à 13:51, stan a écrit :
> I am trting to do something, and it ias not working as I think it should.
>
> Consider:
>
> onnected to a database called stan as stan
>
> /dt reports
>
> List of relations
> Schema | Name | Type | Owner
> +
Il 21/11/19 22:40, Peter J. Holzer ha scritto:
On 2019-11-21 17:27:04 +0100, Moreno Andreo wrote:
Connection refused means somthing has blocked it. If it was all OK and simply
Postgres was not listening, you should've received a "connection timed out"
(10060) message.
Almost exactly the other w
On November 21, 2019 at 19:14:33, Pavel Stehule (pavel.steh...@gmail.com)
wrote:
čt 21. 11. 2019 v 17:19 odesílatel Michael Korbakov
napsal:
> Hi everybody.
>
> I stumbled upon a weird problem with the query planner. I have a query
> on a typical EAV schema:
>
> SELECT contacts.id
> FROM conta
Hi everybody,
I am trying to get all the lexemes for a text using to_tsvector(). But I want
only words that english_stem -- the integrated snowball dictionary -- is able
to handle to show up in the final tsvector. Since snowball dictionaries only
remove stop words, but keep the words that they
I am trting to do something, and it ias not working as I think it should.
Consider:
onnected to a database called stan as stan
/dt reports
List of relations
Schema | Name | Type | Owner
+--+---+---
ica| biz_constants
Yes !
We are looking for something providing a functionnality similar to
Oracle's :-)
Through PITR or a tool or extension around wals.
Still, as wals are containing enough info for replication to work,
It should be possible to extract from wals a list of objects that have been
written, and elemen
I think he wants to see data from different tables at different timestamp
(like flashback query in Oracle). As per my understanding question here is
can PITR be done for specific table and for specific timestamp.
On Fri, Nov 22, 2019 at 2:37 PM Laurenz Albe
wrote:
> On Thu, 2019-11-21 at 17:35 +
On Thu, 2019-11-21 at 17:35 +0100, Marc Millas wrote:
> I was writing select from ""table"" as a template. We have to do this for a
> bunch of tables.
> So, to my understanding, what you suggest is to PITR up to the first
> timestamp,
> extract all meaningfull tables, and then pitr to the second
On Fri, 2019-11-22 at 14:25 +0530, rutuparna andhare wrote:
> In PG , can we have Active1 , Passive1 , Passive2 cluster.
> Now all active1 data is present in passive1 and 2.
> but when any delete query runs on active1 , same should get replicated on
> passive1 But delete should not get trigge
Hi PG,
In PG , can we have Active1 , Passive1 , Passive2 cluster.
Now all active1 data is present in passive1 and 2.
but when any delete query runs on active1 , same should get replicated on
passive1 But delete should not get triggered on passive2.
so passive2 can be used as archival db.
if a
29 matches
Mail list logo