Hi!
Streaming asynchronous binary replication is used with hot standby slave.
To recover disk space
vacuumdb --all --full --skip-locked
is executed in every night is master.
During this vacuumdb stops with error
vacuumdb: error: vacuuming of table "myschema.mytable" in database "mydb" failed
Hi Daniel,
"-P pager=off" works I think you found the root cause.
Thanks for your help.
Arden
On Sun, Apr 5, 2020 at 2:32 PM Daniel Verite
wrote:
> Adrian Klaver wrote:
>
> > On 4/5/20 9:46 AM, Adrian Klaver wrote:
> > > On 4/5/20 5:50 AM, arden liu wrote:
> >
> > > 4) I don't see a
Adrian Klaver wrote:
> On 4/5/20 9:46 AM, Adrian Klaver wrote:
> > On 4/5/20 5:50 AM, arden liu wrote:
>
> > 4) I don't see anything wrong the statements, so I am wondering if it is
> > a shell issue?
>
> Seems to be. I removed the RETURNING *_id from the INSERT statements and
> the fi
Hi Adrian,
I also consider it's related to Shell . Because when I run it from Java , I
don't have this input request.
Let me check some configuration of bash and try again.
Thanks a lot.
Arden
On Sun., Apr. 5, 2020, 2:09 p.m. Adrian Klaver,
wrote:
> On 4/5/20 10:51 AM, arden liu wrote:
> > Do
On 4/5/20 10:51 AM, arden liu wrote:
Does that RETURNING need any user input?
No. I just think actually returning those thousands of values is
stalling the shell. It also not really necessary for the loading as
'INSERT 0 4333' shows you what you need to know. Unless you have super
vision and
Does that RETURNING need any user input?
On Sun., Apr. 5, 2020, 1:10 p.m. Adrian Klaver,
wrote:
> On 4/5/20 9:46 AM, Adrian Klaver wrote:
> > On 4/5/20 5:50 AM, arden liu wrote:
>
> > 4) I don't see anything wrong the statements, so I am wondering if it is
> > a shell issue?
>
> Seems to be. I r
Hi Adrian,
When I use the following java to run the same command, which does not ask
me any input. Maybe bash and java launch another process differently.
-
String command = "/usr/bin/psql postgresql://" +userName + ":" + password
+"@"+ host + ":" + port + "/xbr
When I run any smaller SQL, psql does not ask any keyboard Input. I don't
know what causes this input
On Sun., Apr. 5, 2020, 12:46 p.m. Adrian Klaver,
wrote:
> On 4/5/20 5:50 AM, arden liu wrote:
> > I am using psql to run this sql
> > file(
> https://github.com/Arelle/Arelle/blob/master/arelle/
On 4/5/20 9:46 AM, Adrian Klaver wrote:
On 4/5/20 5:50 AM, arden liu wrote:
4) I don't see anything wrong the statements, so I am wondering if it is
a shell issue?
Seems to be. I removed the RETURNING *_id from the INSERT statements and
the file ran without interruption:
...
CREATE TABLE
On 4/5/20 9:46 AM, Adrian Klaver wrote:
On 4/5/20 5:50 AM, arden liu wrote:
I am using psql to run this sql
file(https://github.com/Arelle/Arelle/blob/master/arelle/plugin/xbrlDB/sql/public/xbrlPublicPostgresDB.ddl)
here is my command:
/usr/bin/psql postgresql://db_user:dbpassword@localhost:5
On 4/5/20 5:50 AM, arden liu wrote:
I am using psql to run this sql
file(https://github.com/Arelle/Arelle/blob/master/arelle/plugin/xbrlDB/sql/public/xbrlPublicPostgresDB.ddl)
here is my command:
/usr/bin/psql postgresql://db_user:dbpassword@localhost:5432/my_db -f
/tmp/xbrlPublicPostgresDB.ddl
On 4/5/20 5:50 AM, arden liu wrote:
I am using psql to run this sql
file(https://github.com/Arelle/Arelle/blob/master/arelle/plugin/xbrlDB/sql/public/xbrlPublicPostgresDB.ddl)
here is my command:
/usr/bin/psql postgresql://db_user:dbpassword@localhost:5432/my_db -f
/tmp/xbrlPublicPostgresDB.ddl
Hi!
Thank you.
>If you decide that it's without, you could apply a TRIM in a trigger on each
>INSERT and UPDATE. Then, you could replace the table by a view of the same
>name >and implement the TRIM on SELECT there. This way, you don't have to
>touch anything in the application.
How you provid
On Sun, Apr 5, 2020 at 7:47 AM Tim Clarke wrote:
> Your first argument is a JDBC connection string (see here
> https://jdbc.postgresql.org/documentation/80/connect.html). To provide
> the details when using the command line psql command, use the -h, -p and
> -U parameters (https://www.postgresql.
Arden
Your first argument is a JDBC connection string (see here
https://jdbc.postgresql.org/documentation/80/connect.html). To provide
the details when using the command line psql command, use the -h, -p and
-U parameters (https://www.postgresql.org/docs/12/app-psql.html)
Tim Clarke
IT Director
> On Apr 5, 2020, at 8:24 AM, David G. Johnston
> wrote:
>
>
>> On Sun, Apr 5, 2020 at 5:50 AM arden liu wrote:
>> I am using psql to run this sql
>> file(https://github.com/Arelle/Arelle/blob/master/arelle/plugin/xbrlDB/sql/public/xbrlPublicPostgresDB.ddl)
>> here is my command:
>> /usr/b
On Sun, Apr 5, 2020 at 5:50 AM arden liu wrote:
> I am using psql to run this sql file(
> https://github.com/Arelle/Arelle/blob/master/arelle/plugin/xbrlDB/sql/public/xbrlPublicPostgresDB.ddl
> )
> here is my command:
> /usr/bin/psql postgresql://db_user:dbpassword@localhost:5432/my_db -f
> /tmp/
I am using psql to run this sql file(
https://github.com/Arelle/Arelle/blob/master/arelle/plugin/xbrlDB/sql/public/xbrlPublicPostgresDB.ddl
)
here is my command:
/usr/bin/psql postgresql://db_user:dbpassword@localhost:5432/my_db -f
/tmp/xbrlPublicPostgresDB.ddl
I do not know why it show me the : ,
Hi Andrus,
Le sam. 4 avr. 2020 à 10:09, Andrus a écrit :
> Hi!
>
> >> In case of varchar field values will appear in database sometimes with
> >> trailing spaces and sometimes without.
> >> This requires major application re-design which much is more expensive
> than
> >> continuing using char f
19 matches
Mail list logo
