HI
At present, I have some requirement to truncate the data base to reclaim disk
space and at the same time I need to take basebackup.
Seems, truncate is successfully reclaimed the space but pgbasebackup failed and
reported the below error.
"could not stat file or directory ./base/16384/25600
Hi,
I have only one database and I ran query with superuser privilege.
Seems this issue is related to BUG 14243.
Regards,
Ramkumar.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Friday, August 12, 2016 7:37 PM
To: Yelai, Ramkumar (CT DD DS AA DF-PD FH
-Original Message-
From: Michael Paquier [mailto:michael.paqu...@gmail.com]
Sent: Tuesday, August 16, 2016 5:51 AM
To: Jeff Janes
Cc: Yelai, Ramkumar (CT DD DS AA DF-PD FH ES); pgsql-general@postgresql.org
Subject: Re: [GENERAL] pgbasebackup is failing after truncate
On Sat, Aug 13, 2016 at
Hi All,
I am using the following code to know how much disk space could be saved after
deleting certain tables (as a parameter to this function )
CREATE OR REPLACE FUNCTION Get_Tables_Recovery_Size( IN tableNames text[] )
RETURNS TABLE( table_size bigint )
AS
$$
DECLARE
BEGIN
RETURN QUE
Hi All,
I have one requirement in my project and don't know how to achieve.
My project is receiving the log information from PC in the network, and that
information is stored in the below table.
CREATE TABLE "PCLogTable"
(
"LOG_ID" serial NOT NULL,
"LOG_USER_ID" integer DEFAULT 0,
"LOG_TY
sday, June 10, 2015 1:48 AM
To: Yelai, Ramkumar IN BLR STS
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] user constructed where clause
On Tue, Jun 9, 2015 at 4:48 AM, Yelai, Ramkumar IN BLR STS
mailto:ramkumar.ye...@siemens.com>> wrote:
Now, the requirement is if user provi
Hi All,
I wanted to compile pgbouncer in Visual studio 2013-64bit.
I have not found any help in forums. Also, pgbouncer source file mentioned
that, it is not tested in Visual studio.
Please let me know, is it possible to compile in VS2013 and works fine?
With best regards,
Ramkumar Yelai
Si
Hi All,
I need some help in postgresql base backup.
We are currently using multiple DBMS in our project and postgresql is one of
them. Our private DBMS keeps the online data and postgresql keeps online as
well as historical data.
At present, we are doing the backup/restore process for our proj
y understand correct? And am I doing the correct way to
backup.
Regards,
Ramkumar.
-Original Message-
From: David Steele [mailto:da...@pgmasters.net]
Sent: Thursday, December 03, 2015 1:27 AM
To: pgsql-general@postgresql.org; Yelai, Ramkumar IN BLR STS
Subject: Re: [GENERAL] Pgbaseba
eele [mailto:da...@pgmasters.net]
Sent: Friday, December 04, 2015 6:26 PM
To: Yelai, Ramkumar IN BLR STS; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pgbasebackup help
On 12/3/15 12:59 AM, Yelai, Ramkumar IN BLR STS wrote:
> What I wanted to achieve is simple copy of Data folder. I
Hi
I have migrated my postgresql 9.2 schemas to Postgres 9.4 (only table scheme
migrated not the data ). I have used the following sql to convert table output
to json in 9.2.
select array_to_json(array_agg(row_to_json(R.*)))::text from ( select " ID", "
TIME" from "SN_TestTable" )R;
IN 9.2,
HI
In our current project, we are opening several postgresql connection. Few
connections are frequently used and few are occasionally used. Hence we plan to
adapt connection pool method to avoid more connection to open. We plan to use
"Pgbouncer". Most of the pgbouncer example shows how to
---
From: Jeff Janes [mailto:jeff.ja...@gmail.com]
Sent: Tuesday, August 27, 2013 11:10 PM
To: Yelai, Ramkumar IN BLR STS
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pgbouncer help
On Tue, Aug 27, 2013 at 1:34 AM, Yelai, Ramkumar IN BLR STS
wrote:
> HI
>
>
>
> In our current project
Thanks for your great inputs.
Let me see, how to handle these situations in our project.
Regards,
Ramkumar
-Original Message-
From: Steve Crawford [mailto:scrawf...@pinpointresearch.com]
Sent: Wednesday, August 28, 2013 1:09 AM
To: Jeff Janes
Cc: Yelai, Ramkumar IN BLR STS; pgsql
Hi All,
We are using postgreql 9.2 as a main backend server for our project. We have
been using this server since last year. We have configured postgresql as a
windows service. Till last week, we have not faced any issues to start server
from service console management, but last week we hav
Hi All,
I am a beginner in Postgresql and Databases. I have a requirement that
reclaiming disk space by deleting the rows in a selected time span. I went
through the documents and articles to know how to get the table size
(http://wiki.postgresql.org/wiki/Disk_Usage)
But before let the user d
I need to consider
carefully while doing this?
Thanks & Regards,
Ramkumar
_
From: Yelai, Ramkumar IN BLR STS
Sent: Thursday, September 13, 2012 7:03 PM
To: 'pgsql-general@postgresql.org'
Subject: Need help in reclaiming disk space b
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Friday, September 28, 2012 1:07 PM
To: Yelai, Ramkumar IN BLR STS; pgsql-general@postgresql.org
Cc: scrawf...@pinpointresearch.com; and...@2ndquadrant.com
Subject: RE: [GENERAL] Re: Need help in reclaiming disk
Hi All,
Please clarify me the following example.
I have 2 tables
Table1 - ( it has one primary key and few columns )
Table2 - ( it has one primary key and few columns. It has one foreign key,
which refers table1 primary key ).
I have 2 operations, which are written in pl/pgsql procedure.
or I have write some example programming code on
this.
Thanks & Regards,
Ramkumar
From: Moshe Jacobson [mailto:mo...@neadwerx.com]
Sent: Wednesday, October 31, 2012 9:01 PM
To: Albe Laurenz
Cc: Yelai, Ramkumar IN BLR STS; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Parallel Insert
Ramkumar Yelai wrote:
[is worried that a database might become inconsistent if conflicting INSERTs
and DELETEs occur]
> @Albe - I got you first point. The second point is little skeptical
because postgres could have been
> avoided this lock by using MVCC. Please correct me if I am wrong?
Which
21 matches
Mail list logo
