and alter the table column to modify the
datatype of the columns. Am I correct? or is there any other way to resolve
it.
--
Regards,
Raghavendra Rao J S V
dministrator command
pg_dump: could not open large object 59087743: FATAL: terminating
connection due to administrator command
FATAL: terminating connection due to administrator command
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
to PG. They are not supported through PGBouncer.
>
>
>
> *From:* Raghavendra Rao J S V [mailto:raghavendra...@gmail.com]
> *Sent:* Monday, April 8, 2019 9:21 AM
> *To:* pgsql-general@lists.postgresql.org
> *Subject:* Getting error while running the pg_basebackup through PGB
: replication*
--
Regards,
Raghavendra Rao J S V
Hi All,
We are using Postgresql 9.2 database.
In one of the transactional table, I have observed duplicate values for the
primary key columns.
Please guide me how is it possible and how to fix this kind of issue.
--
Regards,
Raghavendra Rao J S V
its
dependent tables using *pg_dump *command.
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
In my application, the idle sessions are consuming cpu and ram. refer the
ps command output.
How idle session will consume more ram/cpu?
How to control it?
We are using Postgresql 9.2 with Centos 6 os. Please guide me.
[image: image.png]
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
Hi All,
We are using *pg_dump *backup utility in order to take the backup of the
database. Unfortunately,it is taking around 24hrs of time to take the
backup of 28GB database. Please guide me how to reduce the time and is
there any parameter need to be modified which will help us to reduce the
b
Thanks a lot.
On Mon, 15 Oct 2018 at 14:43, Jehan-Guillaume (ioguix) de Rorthais <
iog...@free.fr> wrote:
> On Mon, 15 Oct 2018 09:46:47 +0200
> Laurenz Albe wrote:
>
> > Raghavendra Rao J S V wrote:
> > > Is there any impact if "#wal_keep_segments = 0 "
pletion_target = 0.5 # checkpoint target duration, 0.0 - 1.0
#checkpoint_warning = 30s # 0 disables
*#wal_keep_segments = 0* # in logfile segments, 16MB each; 0 disables
wal_level = archive # minimal, archive, or hot_standby
*archive_mode = off* # allows archiving to be done
--
Regards,
Raghavendra Rao J S V
-
> *De:* Johnes Castro
> *Enviado:* quarta-feira, 5 de setembro de 2018 15:48
> *Para:* Raghavendra Rao J S V; pgsql-general@lists.postgresql.org
> *Assunto:* RE: Max number of WAL files in pg_xlog directory for Postgres
> 9.2 version
>
> Hi,
>
> This page in the d
Thank you very much for your prompt response Christopher.
On Thu 11 Oct, 2018, 8:41 AM Christopher Browne, wrote:
> On Wed, Oct 10, 2018, 10:32 PM Raghavendra Rao J S V <
> raghavendra...@gmail.com> wrote:
>
>> Hi All,
>>
>> pg_dump is taking more time. Pleas
t; Regards,
> Pavan
>
> On Thu, Oct 11, 2018, 8:02 AM Raghavendra Rao J S V <
> raghavendra...@gmail.com> wrote:
>
>> Hi All,
>>
>> pg_dump is taking more time. Please let me know which configuration
>> setting we need to modify to speedup the pg_dum
Hi All,
pg_dump is taking more time. Please let me know which configuration setting
we need to modify to speedup the pg_dump backup.We are using 9.2 version on
Centos Box.
--
Regards,
Raghavendra Rao J S V
t_metadata
--
Regards,
Raghavendra Rao J S V
,,""
2018-10-08 05:27:44.517 UTC,,,27686,,5bbaead0.6c26,2,,2018-10-08 05:27:44
UTC,,0,LOG,0,"aborting startup due to startup process
failure",""
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
On Fri, 5 Oct 2018 at 07:06, Thomas Munro
wrote:
> On Fri, Oct 5, 2018 at 4:29 AM Raghavendra Rao J S V
> wrote:
> > PANIC: could not read from control file:Success
>
> That means that the pg_control file is the wrong size. What size is
> it? What filesystem is this, t
file:Success*
Please help me to resolve the above error.
--
Regards,
Raghavendra Rao J S V
chael Paquier wrote:
> On Fri, Sep 28, 2018 at 06:19:16AM -0700, Adrian Klaver wrote:
> > If log_truncate_on_rotation = 'on', correct?
>
> Yup, thanks for precising.
> --
> Michael
>
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
Thanks for the prompt response.
On Fri 28 Sep, 2018, 10:55 AM Michael Paquier, wrote:
> On Fri, Sep 28, 2018 at 10:33:30AM +0530, Raghavendra Rao J S V wrote:
> > Log file will be generated in *csv* format at *pg_log* directory in our
> > PostgreSQL. Every day we are getting o
,
Raghavendra Rao J S V
Mobile- 8861161425
Hi All,
Which is the most stable PostgreSQL version yet present for CentOS 7?
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
?
--
Regards,
Raghavendra Rao J S V
lp me.
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
what it means *--pgdata=--D* in my above * pg_basebackup *
command.
--
Regards,
Raghavendra Rao J S V
budget.
>
> On Sun, Aug 26, 2018, 12:37 AM Raghavendra Rao J S V <
> raghavendra...@gmail.com> wrote:
>
>> Thank you very much for your prompt response.
>>
>> Please guide me below things.
>>
>> How to check rows got corrupted?
>>
>>
:
> On 08/25/2018 08:36 PM, Raghavendra Rao J S V wrote:
> > Hi All,
> >
> > One of our database size is 50gb. Out of it one of the table has
> > 149444622 records. Size of that table is 14GB and its indexes size is
> 16GB.
> > Total size of the table and its in
"idx_tab_col6date" btree (col6date)
"idx_tab_rid" btree (rid)
"idx_tab_rtype_id" btree (rtypid)
"idx_tab_tkey" btree (tkey)
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
suggest me the steps / provide me a URL to implement?
--
Regards,
Raghavendra Rao J S V
suggest me the steps / provide me a URL to implement?
--
Regards,
Raghavendra Rao J S V
that table in
postgresql database.
--
Regards,
Raghavendra Rao J S V
Thanks a lot.
On Sun 19 Aug, 2018, 11:09 PM Adrian Klaver,
wrote:
> On 08/19/2018 10:22 AM, Raghavendra Rao J S V wrote:
> > Hi All,
> >
> > I have a log file as "
> > */opt/postgres/9.2/data/pg_log/postgresql-2018-08-19.csv*". Due to
> > "*log
lot of raise notice messages , I would like to create a new log file
instead of appending the logs to existing one. How to achieve this?
Like this each and every execution of my function, I wold like to get a new
log file. How to do this.
--
Regards,
Raghavendra Rao J S V
?
Regards,
Raghavendra Rao
On 17 August 2018 at 09:30, Joshua D. Drake wrote:
> On 08/16/2018 06:10 PM, Raghavendra Rao J S V wrote:
>
> Hi All,
>
> I have gone through several documents but I am still have confusion
> related to "autovacuum_naptime" and "auto
s Auto vacuum worker process will sleep like Auto vacuum launcher
process ?
What is the difference between Auto vacuum launcher process and Auto vacuum
worker process?
--
Regards,
Raghavendra Rao J S V
00*
*Kindly guide me your views. Does it cause any adverse effect on DB.*
Regards,
Raghavendra Rao
On 13 August 2018 at 18:05, Tomas Vondra
wrote:
>
>
> On 08/13/2018 11:07 AM, Raghavendra Rao J S V wrote:
>
>> Hi All,
>>
>> We are using postgres *9.2* versio
Hi All,
We are using postgres *9.2* version on *Centos *operating system. We have
around *1300+* tables.We have following auto vacuum settings are enables.
Still few of the tables(84 tables) which are always busy are not
vacuumed.Dead tuples in those tables are more than 5000. Due to that
table
. Later we
are restarting the application server process.
How to avoid accumulating the dead tuples for those tables. Is there any
other approach to remove the dead tuple’s without vacuum full/down time.
Note:- We are using the postgres version 9.2
--
Regards,
Raghavendra Rao J S V
Mobile
. Thanks in advance.
--
Regards,
Raghavendra Rao J S V
constraint
"pg_statistic_relid_att_inh_index"*
DETAIL: Key (starelid, staattnum, stainherit)=(18915, 6, f) already exists.
' pg_statistic ' is a meta data table. Is it ok if I remove one duplicated
record from ' pg_statistic' table?.
--
Regards,
Raghavendra Rao J S V
Thanks a lot.
On Wed 11 Apr, 2018, 9:07 AM Michael Paquier, wrote:
> On Tue, Apr 10, 2018 at 11:06:54PM +0530, Raghavendra Rao J S V wrote:
> > I am not clear the difference between checkpoint_segments and
> > wal_keep_segments .
> >
> > I would like to now below th
it" to zero or "
autovacuum_vacuum_scale_factor" to zero or both? Please clarify me.
Regards,
Raghavendra Rao
On Wed, Apr 11, 2018 at 12:59 PM, Laurenz Albe
wrote:
> Raghavendra Rao J S V wrote:
> > We are using postgres 9.2 version on Centos operating system. We
am planning to make '
autovacuum_vacuum_scale_factor'
value to zero and autovacuum_vacuum_threshold value to 150. Please
suggest me does it have any negative impact.
--
Regards,
Raghavendra Rao J S V
*
- Which one should has higher value.
--
Regards,
Raghavendra Rao J S V
eters?
- shared_buffers
- effective_cache_size
- work_mem
- maintenance_work_mem
- checkpoint_segments
- wal_keep_segments
- checkpoint_completion_target
- Max_prepared_transactions =0
--
Regards,
Raghavendra Rao J S V
Hi,
How to install pgTAP on Centos machine.? I tried to install but no luck.
Please guide me to proceed further.
--
Regards,
Raghavendra Rao J S V
Good morning.
Please suggest the best suited unit test frame work for postgresql database
and also shared the related documents to understand the framework.
--
Regards,
Raghavendra Rao J S V
oast_2619_index"*
*CONTEXT: automatic vacuum of table "qovr.pg_toast.pg_toast_2619"*
--
Regards,
Raghavendra Rao J S V
which are
performed by me.
--
Regards,
Raghavendra Rao J S V
HEN OTHERS THEN
RAISE NOTICE 'Error occurred while executing
pop_new_deviceid_for_table for % table % %', p_table,SQLERRM,
SQLSTATE;
PERFORM insert_log('ERROR' ,'pop_new_deviceid_for_table' ,'Error
occurred while executing pop_endpoints
I am looking for the help to minimise the time taken by the pg_basebackup
utility.
As informed Earlier we are taking the backup of the database using
pg_basbackup utility using below command.
$PGHOME/bin/pg_basebackup -p 5433 -U postgres -P -v -x --format=tar --gzip
--compress=6 --pgdata=- -D /op
value?
Please let me know what does this means.
*Please don't top-post on the PG mailing lists.*
*How to get clarifications on my query?*
On Sat, Jan 13, 2018 at 9:52 PM, Stephen Frost wrote:
> Greetings,
>
> Please don't top-post on the PG mailing lists.
>
> * Raghavend
ement.
$PGHOME/bin/pg_basebackup -p 5433 -U postgres -P -v -x --format=tar --gzip
--compress=6 --pgdata=- -D /opt/backup_db
On Fri, Jan 12, 2018 at 6:37 PM, Stephen Frost wrote:
> Greetings,
>
> * Raghavendra Rao J S V (raghavendra...@gmail.com) wrote:
> > We have database with the siz
). Please guide me
what are the configuration parameters need to modify to reduce the time
taken by the pg_basebackup utility.
Is there any possibility to exclude the index data while taking the
pg_basebackup?
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
54 matches
Mail list logo
