Hi all
I bumped into a weird case that i don't really understand...maybe someone in this list could have a clue
We have 2 Postgres databases configured as master/slave replica (Postgresq 12, RHEL8)
We have applications which write data into the master and applications which reads data from the
In libpq, in the code of the lo_import function, for each piece of a file
of 8KB in size, lo_write is called, which greatly slows down the work of
lo_import because lo_write sends a request and waits for a response. The
size of 8KB is specified in define LO_BUFSIZE which changed from 1KB to 8KB
24
PG 14.10 (and 9.6.24, which we're migrating off of).
EXPLAIN SELECT works inside a FOR loop, but only the first line of the
EXPLAIN output is stored. What's the magic sauce for seeing the whole
EXPLAIN output?
(The purpose is to generate many queries and see how the BIND and SELECT
times change
Hi Team,
1. We are using Windows server . How to set up Kerberos authentication?
2.How to set up/create/use SSPI authentication?
3.Like MSSQL server windows authentication is it possible in postgresql
server?
I tried to search through Google,youtube and chatgpt also. I'm unable to
get clarity on
I am using postgres v.14 on rhel8
I enabled the track_commit_timestamp parameter.
postgres [379418]=# show track_commit_timestamp ;
┌┐
│ track_commit_timestamp │
├┤
│ on │
└┘
(1 row)
I performed a recover
Good morning to all.
I'd need some advice.
I'm trying to install PgAdmin4 from its repository, on Debian 11,
by the instructions in the concerning page in www.postgresql.org. The
installation fails, as the packages cannot be verified. What shoud I
do? I tried using deb [trusted=yes], but under
Hi all,
How to take a table backup using directory format?
I am having huge size of table when I am using a pg_dump it tooks more time
kindly suggest me
Hi ,
What type of temp database should i use to maintain logs or export logs?
Thanks
Rama-krishnan
Hi -
Does anyone use the gawk extension? I think it is the coolest thing.
I see that it installed .so files on my system from the fedora package
manager but there is no .sql file or control file in the extension
directory.
I searched with kfind utility and didn't find anything.
I can't seem to
Hi,
After pg_repack do we face any perfomancr issue or any other issues in
production DB
Hi All,
How to install pg_repack and use?
Thanks
RamaKrishnan
Hi,
Can I add custom sqls for regression tests (pg_regress) ?
If it can be added how?
Dennis
Postgres 9.6. We're attempting to delete some old users from a DB.
Log into DB as masteruser.
Run this block of commands (the_schema=public, and it's the only schema in
this particular DB):
REVOKE ALL PRIVILEGES ON DATABASE the_database FROM old_role;
REVOKE USAGE ON SCHEMA the_schema FROM old_r
Hi everyone
is there any one working on PostgreSQL windows machine.
Thank you & Regards
Obireddy.G
Hi everyone.
how to take incremental backup in postgresql windows machine.
Thank you And Regards
Obireddy.G
How measure table total pages (block) count? would be this correct way? :
SELECT pg_table_size('my_table'::regclass) /
current_setting('block_size')::BIGINT;
Igor Korot writes:
> On Fri, Jul 2, 2021, 5:24 AM Atul Kumar wrote:
>> -> Seq Scan on sam_participant pp (cost=0.00..777393.87 rows=56113
>> width=10) (actual time=0.277..10869.750 rows=2335154 loops=1)
>> Filter: ((igroupid)::integer =
>> (current_setting('env.groupid'::text))::integer
Hi,
I have one query like below :
SELECT
m.iMemberId "memberId",
m.cFirstName "firstName",
m.cLastName "lastName",
m.cFirstName || ' '
"David G. Johnston" writes:
> Given this, should the configuration description for this include the "This
> parameter can only be set in postgresql.conf file or on the server command
> line." comment,
Hmm, yeah, it does lack the standard boilerplate for a PGC_POSTMASTER
GUC. I wonder which other
"David G. Johnston" writes:
> On Monday, May 17, 2021, Tom Lane wrote:
>> It looks like it won't be started if you set
>> max_logical_replication_workers = 0.
> I was wondering about that. Would you mind posting a link to the code
> where that is checked? I actually looked though admittedly no
"David G. Johnston" writes:
> On Sunday, May 16, 2021, Loles wrote:
>> I don't understand why the server starts that process if I'm not using
>> replication of any kind.
> It starts the process because at any time someone can execute a “create
> subscription” command. If no one does so the amo
Hi!
Let's see if someone can answer my question.
In a default PostgreSQL 13 installation, starting the server starts a
process called "logical replication launcher".
I know what logical replication is but I don't know what this process does
on the server.
Even if you change the default setting
Hello All,
I have the following table:
postgres=# \d so_rum;
Table "public.so_rum"
Column | Type | Collation | Nullable | Default
---+-+---+--+-
id| integer
subscribeend
Hello,
I am running postgres 11.5 and we were having issues with shared segments.
So I increased the max_connection as suggested by you guys and reduced my
work_mem to 600M.
Right now instead, it is the second time I see this error :
ERROR: could not resize shared memory segment "/PostgreSQL.213
Hi,
I am new to this list and reaching out because I am having troubles setting
up a local PostgreSQL database on my laptop. Maybe, as a preamble, I should
say that I am pretty much a novice trying to teach myself and get practical
experience about database and SQL queries (I have some general ide
Hello ,
does postgresql with react native allow us to create chat applications?
Is there any option to run reindex or vaccum in background?
Every time the session gets logged off in between.
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
Hello All,
Is it possible check privileges of all the users or roles, and what are the
objects owned by user and role with their privileges.
I am getting the output which want from
information_schema.roles_usage_grants, but as I not running the query as a
superuser so I am able to see only one sp
Hi All,
In order to implment connection pool mechanisam, we have decided to use
pg_bouncer. But due to some dependent software's like openssl we are not
going to use pg_bouncer.
Therefore we are planning to use pgpool to implement the connection pool
mechanisam in my applicaiton.
We don't have m
Can I split a large file into multiple files and then run copy using each file.
The table does not contain any serial or sequence column which may need
serialization. Let us say I split a large file to 4 files. Will theperformance
boost by close to 4x??
Hi,
is there a way to find if a certain page in a data file is referenced by a
btree index?
I found a few completely empty pages in one of my tables. I am not sure if
that's corruption or just bloat. Now I am thinking I could use an index,
the PK for instance, and see if it references these pages
Dont mail me plase unsubscribe
ÑAO EÑTENĎI
Hi friends,
This is Ramar and i have accidentally deleted database in postgresql
through pg admin.
My backup restore not working.
Can i recover my deleted database in postgresql.
Anyone having solution kindly reply me.
Thanks & Regards,
Ramar D
38 matches
Mail list logo
