Hello,
I encountered a problem on replicas after the primary crashed for lack of disk
space.
After the problem I had a constant flow of "invalid contrecord" logs and
replication ceased working.
The only way I found to make it work again was to completely restart the
replica.
The logs:
Jun
Prakash Ramakrishnan wrote:
> While restoring the database using psql getting below error any idea about
> this?
>
> psql:AICH01PR.sql:641367264: ERROR: connection for foreign table
> "mf_adm_spotservicefiles" cannot be established
> DETAIL: ORA-12170: TNS:Connect timeout occurred
Just guessi
Thanks, I'll check it out.
Regards,
Prakash.R
On Tue, Jul 2, 2019 at 1:05 PM Laurenz Albe
wrote:
> Prakash Ramakrishnan wrote:
> > While restoring the database using psql getting below error any idea
> about this?
> >
> > psql:AICH01PR.sql:641367264: ERROR: connection for foreign table
> "mf_a
Hi Team,
We are getting below error while during import the csv file please do the
needful.
CREATE TABLE ujshjk ( pod_id bigint NOT NULL, src_id smallint, eff_strt_dt
date,eff_end_dt date,ins_dt timestamp without time zone,updt_dt timestamp
without time zone,nat_key_1 character(50),nat_key_2 char
Ron wrote:
> v9.6.9
>
> Statistics views like pg_stat_*_tables, pg_stat_*_indexes, pg_statio_*_tables
> and pg_statio_*_indexes
> aren't being updated anymore. Specifically, all counter fields are 0, and
> date fields are blank.
>
> The first thing I checked was postgresql.conf (but it hasn't b
On Tue, 2019-07-02 at 13:09 +0530, Prakash Ramakrishnan wrote:
> We are getting below error while during import the csv file please do the
> needful.
I'd say the needful thing here is for you to read the documentation...
> -bash-4.2$ more ckr_sto.csv
> 4937880 | 12 | 2015-01-05 |
Thanks a lot. I will check and let you know.
Regards,
Prakash.R
On Tue, Jul 2, 2019 at 1:15 PM Laurenz Albe
wrote:
> On Tue, 2019-07-02 at 13:09 +0530, Prakash Ramakrishnan wrote:
> > We are getting below error while during import the csv file please do
> the needful.
>
> I'd say the needful th
Hi again,
Looking more at sequences, I have some sequences that start with ID 1,
incrementing each record by 1.
So I have e.g. 1 Spain 2. Germany 3. France 4. Ireland 5. Norway
Now I want to insert more countries, between France and Ireland. And also alter
the increment. That latter part might b
Karl Martin Skoldebrand schrieb am 02.07.2019 um 12:44:
> Looking more at sequences, I have some sequences that start with ID 1,
> incrementing each record by 1.
>
> So I have e.g. 1 Spain 2. Germany 3. France 4. Ireland 5. Norway
>
> Now I want to insert more countries, between France and Irela
Karl Martin Skoldebrand schrieb am 02.07.2019 um 12:44:
> Looking more at sequences, I have some sequences that start with ID 1,
> incrementing each record by 1.
>
> So I have e.g. 1 Spain 2. Germany 3. France 4. Ireland 5. Norway
>
> Now I want to insert more countries, between France and Irela
On Tue, Jul 02, 2019 at 11:20:42AM +, Karl Martin Skoldebrand wrote:
> Yes, I'm fairly aware of this. However the application the database table
> belongs to seems to rely on a specific order in the database. I.e. if I just
> add value to the table they end up, possibly due to how the applic
> Yes, I'm fairly aware of this. However the application the database table
> belongs to seems to rely on a specific order in the database. I.e. if I just
> add value to the table they end up, possibly due to how the application is
> coded in an undesireable spot on the web page.
> That is why
Karl Martin Skoldebrand schrieb am 02.07.2019 um 13:20:
>>> Now I want to insert more countries, between France and Ireland.
>>
>> That is a wrong assumption - there is no "between" for rows in a
>> relational database.
>>
>
> Yes, I'm fairly aware of this. However the application the
> databas
On 7/1/19 1:48 PM, Tom Lane wrote:
Ron writes:
Statistics views like pg_stat_*_tables, pg_stat_*_indexes,
pg_statio_*_tables and pg_statio_*_indexes aren't being updated anymore.
Specifically, all counter fields are 0, and date fields are blank.
Does anything show up in the postmaster log when
On 7/2/19 6:28 AM, Ron wrote:
On 7/1/19 1:48 PM, Tom Lane wrote:
Ron writes:
Statistics views like pg_stat_*_tables, pg_stat_*_indexes,
pg_statio_*_tables and pg_statio_*_indexes aren't being updated anymore.
Specifically, all counter fields are 0, and date fields are blank.
Does anything sho
Dirk Mika writes:
> But when I try to modify a field of a record in the array I get a syntax
> error.
> l_classes_array[i].field1 := l_value;
> The error is ERROR: syntax error at or near "." Position: 12414 where
> position points to the . after the [i]. I've no idea what's causing this
> synt
Hello,
FYI, check_pgactivity has a service to detect frozen stat collector:
https://github.com/OPMDG/check_pgactivity#user-content-stat_snapshot_age-9.5
We added this service after a customer has deactivated IPv6 that broke stat
collector.
Regards,
signature.asc
Description: OpenPGP digital s
Anyone with a test scripts or link to an example of bi-directional master using
pglogical. ?
I am led to believe from the documentation that this should be possible. (?)
"Limited multi-master support with conflict resolution exists, but mutual
replication connections must be added individually"
W
Laurenz Albe wrote:
> On Tue, 2019-07-02 at 13:09 +0530, Prakash Ramakrishnan wrote:
> > We are getting below error while during import the csv file please do the
> > needful.
>
> I'd say the needful thing here is for you to read the documentation...
>
> > -bash-4.2$ more ckr_sto.csv
> > 49378
Yes, CSV stands for comma separated variable length. This means that the
fields in each row should be separated by commas, with a carriage return at
the end of each record. You have a file using | separators, which mean it
is not csv.
On Tue, Jul 2, 2019 at 6:04 PM wrote:
> Laurenz Albe wrote:
On 7/2/19 4:08 PM, Andrew Kerber wrote:
Yes, CSV stands for comma separated variable length. This means that
CSV = Comma Separated Values
the fields in each row should be separated by commas, with a carriage
return at the end of each record. You have a file using | separators,
which mean i
Dirk Mika wrote:
> Hi,
>
> Another Oracle -> PostgreSQL Question. ☺
>
> I try to migrate a package procedure. Local types were declared in the Oracle
> package:
>
> TYPE t_class_record IS RECORD
> (
> id_class classes.id_class%TYPE,
> field1 number,
> field2
--
Dirk Mika
Software Developer
mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany
fon +49 2202 2401-1197
dirk.m...@mikatiming.de
www.mikatiming.de
AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika
## How2Use
## the ChampionCh
--
Dirk Mika
Software Developer
mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany
fon +49 2202 2401-1197
dirk.m...@mikatiming.de
www.mikatiming.de
AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika
## How2Use
## the Champion
All,
We are glad that we have this feature that allows us to load balance reads.
that has helped us a lot.
https://paquier.xyz/postgresql-2/postgres-10-multi-host-connstr/
I would like to know if it is possible to request a similar enhancement to
FDWs too?
https://www.postgresql.org/docs/11/sql-c
25 matches
Mail list logo
