-Original Message-
From: Steve Atkins [mailto:st...@blighty.com]
Sent: Tuesday, May 22, 2018 12:44 AM
To: PG-General Mailing List
Cc: bdmyt...@gmail.com
Subject: Re: posgresql.log
> On May 21, 2018, at 3:21 PM, Steve Crawford
> wrote:
>
>
>
> If this is a test server and you can
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 22, 2018 12:03 AM
To: Bartosz Dmytrak ; pgsql-gene...@postgresql.org
Subject: Re: posgresql.log
On 05/21/2018 02:40 PM, Bartosz Dmytrak wrote:
> Hi Gurus,
>
> Looking into my postgresql.log on
When I start my postgresql server I get 11 messages reporting that "password
authentication failed for user 'postgres'" spaced about ~.5sec apart.
I increased the logging level to INFO, and added the application name to the
message format (after the pid) which resulted in:
2018-05-21 23:04:44.3
I believe that we have figured it out. It indeed was a WAL issue — the WAL
wasn’t getting measured because it had been moved into an archived folder.
We resolved this in a two main ways:
1. By dramatically increasing max_wal_size to decrease the frequency of commits
2. By turning on wal_compress
On 05/21/2018 04:40 PM, Bartosz Dmytrak wrote:
Hi Gurus,
Looking into my postgresql.log on one of my test servers I found scary entry:
--2018-05-19 05:28:21-- http://207.148.79.161/post0514/post
Connecting to 207.148.79.161:80... connected.
HTTP request sent, awaiting response... 200 OK
Len
> On May 21, 2018, at 3:21 PM, Steve Crawford
> wrote:
>
>
>
> If this is a test server and you can take it offline for forensics I would do
> so, especially if it could provide a path to other internal or critical
> resources. If you can image it for safekeeping and forensics, even better.
On Mon, May 21, 2018 at 2:40 PM Bartosz Dmytrak wrote:
> Hi Gurus,
>
> Looking into my postgresql.log on one of my test servers I found scary
> entry:
>
>
>
> --2018-05-19 05:28:21-- http://207.148.79.161/post0514/post
>
> Connecting to 207.148.79.161:80... connected.
>
> HTTP request sent, awai
On 05/21/2018 02:40 PM, Bartosz Dmytrak wrote:
Hi Gurus,
Looking into my postgresql.log on one of my test servers I found scary
entry:
Is there a Web app running on this server?
The log entries below are from the Postgres logs in?:
/var/log/postgresql/
--2018-05-19 05:28:21-- http://207
Hi Gurus,
Looking into my postgresql.log on one of my test servers I found scary entry:
--2018-05-19 05:28:21-- http://207.148.79.161/post0514/post
Connecting to 207.148.79.161:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1606648 (1.5M) [application/octet-stream]
On Mon, May 21, 2018 at 12:54:56PM -0400, Tom Lane wrote:
> Alexey Dokuchaev writes:
> > Quick reality check question: are count(*) vs. count(_) equivalent
> > above?
>
> Only if _ is guaranteed non-null ... which, as a rowtype result, it
> probably is. But I'd use count(*) if you're concerned a
Greetings,
* Christoph Moench-Tegeder (c...@burggraben.net) wrote:
> ## Yashwanth Govinda Setty (ygovindase...@commvault.com):
>
> > 2. Restore the server with transaction logs
>
> This is missing a lot of details. If you do it right - see your email
> thread from one week ago - you will be a
Alexey Dokuchaev writes:
> Quick reality check
> question: are count(*) vs. count(_) equivalent above?
Only if _ is guaranteed non-null ... which, as a rowtype result, it
probably is. But I'd use count(*) if you're concerned about speed.
regards, tom lane
## Yashwanth Govinda Setty (ygovindase...@commvault.com):
> 2. Restore the server with transaction logs
This is missing a lot of details. If you do it right - see your email
thread from one week ago - you will be able to recover the database
server to a state as of the _end_ of the backup proc
On Mon, May 21, 2018 at 12:20:52PM -0400, Tom Lane wrote:
> Alexey Dokuchaev writes:
> > On Mon, May 21, 2018 at 10:45:27AM -0400, Tom Lane wrote:
> >> OP could do something like
> >>select json_agg(_) as j, count(*) as c INTO r FROM (
>
> > Thanks, I've arrived at the same solution (using lo
Greetings,
* Yashwanth Govinda Setty (ygovindase...@commvault.com) wrote:
> 1. Creating a big table. Identify the physical file on the disk.
> 1. While backup process is backing up a file associated with the table -
> update the rows , add a column.
> 2. Restore the server with transactio
Alexey Dokuchaev writes:
> On Mon, May 21, 2018 at 10:45:27AM -0400, Tom Lane wrote:
>> OP could do something like
>> select json_agg(_) as j, count(*) as c INTO r FROM (
> Thanks, I've arrived at the same solution (using local RECORD) eventually.
> It works as intended, but I still need to
Not sure if such case would corrup the backup, but I won't make a backup just
by copying the data directory.
Use pg_basebackup instead, it's safer
Regards,
Alvaro Aguayo
Operations Manager
Open Comb Systems E.I.R.L.
Office: (+51-1) 3377813 | Mobile: (+51) 995540103 | (+51) 954183248
Web: www.o
On Mon, May 21, 2018 at 10:45:27AM -0400, Tom Lane wrote:
> OP could do something like
>
> declare r record;
> ...
> select json_agg(_) as j, count(*) as c INTO r FROM (
> SELECT foo, bar, baz ...
> FROM t1, t2, t3 WHERE ...) AS _;
>
> This would be slightly more expensive
Hi All,
We are trying this scenario:
Here are the steps being done:
1. Creating a big table. Identify the physical file on the disk.
1. While backup process is backing up a file associated with the table -
update the rows , add a column.
2. Restore the server with transaction logs
Should work with no problem, but I would not recommend it. You may not be able
to setup a service(SysV or systemd) to automatically start postgres, and
updating version could be troublesome.
Regards,
Alvaro Aguayo
Operations Manager
Open Comb Systems E.I.R.L.
Office: (+51-1) 3377813 | Mobile:
Thiagarajan Lakshminarayanan writes:
> Thanks Benjamin. Actually, we don't use Docker in our environment. We just
> use a standard RHEL OS install. Will there be any issues if I install
> PostgreSQL by extracting the RPM binaries?
What exactly is your purpose here? Is it just that you want to r
Thanks Benjamin. Actually, we don't use Docker in our environment. We just
use a standard RHEL OS install. Will there be any issues if I install
PostgreSQL by extracting the RPM binaries?
Please let me know.
Thanks
Raj
On Mon, May 21, 2018 at 10:15 AM, Benjamin Scherrey <
scher...@proteus-tech.
You know this is something super easy to do if you do it within Docker.
Advise you to go ahead and map the data directories to the host file system
rather than use a storage container until you get a lot more experience
with Docker. Otherwise it's crazy easy and, in fact, there already exist
Docker
"David G. Johnston" writes:
>> Is it possible to obtain the
>> first ROW_COUNT (after SELECT) without performing it twice?
> Not directly, no. You should execute the inner query to a temporary table
> than perform your counting and json_agg from that.
OP could do something like
declar
On 05/21/2018 05:54 AM, Alexey Dokuchaev wrote:
Hi,
I'm seeing somewhat confusing results here with 9.6.8, and cannot find
the answer in the docs or google.
I'm returning JSON array (or any array, it does not make a difference)
from my plpgsql function like this:
OUT retcode int,
OUT
On Mon, May 21, 2018 at 5:54 AM, Alexey Dokuchaev wrote:
> result := json_agg(_) FROM (
> SELECT foo, bar, baz ...
> FROM t1, t2, t3 WHERE ...) AS _; -- this works fine
>
> GET DIAGNOSTICS retcode = ROW_COUNT;-- always returns 1
>
> I'd expected `retcode' to c
Hello,
In our environment, our standard RHEL OS install comes with all the
PostgreSQL required packages / libraries installed. So, can I just extract
the binaries from PostgreSQL RPMs via rpm2cpio and create a tar file and
install it as non-root user in an alternate location? I tested the above
Hi,
I'm seeing somewhat confusing results here with 9.6.8, and cannot find
the answer in the docs or google.
I'm returning JSON array (or any array, it does not make a difference)
from my plpgsql function like this:
OUT retcode int,
OUT result json)
. . .
result := json_agg(_) FR
On Sun, May 20, 2018 at 10:15 PM, Deepti Sharma S <
deepti.s.sha...@ericsson.com> wrote:
> Hello Team,
>
> Can you please let us know what postgre version is compatible with
> RHEL7.5? We are currently using Postgre version 9.6.6.
>
9.6.6 is compatible but not supported - the current supported r
Hello.
We are on Postgresql version 9.6.6. We have 2 EC2 instances in different
Amazon regions and we are doing physical replication via VPN. It all seems
to work just fine most of the time. I'm noticing in the logs that we have
recurring erros (maybe 10 or 12 times per day) that look like t
El 21/05/18 a las 02:15, Deepti Sharma S escribió:
> Hello Team,
>
> Can you please let us know what postgre version is compatible with RHEL7.5?
> We are currently using Postgre version 9.6.6.
Please, don't hijack other threads just changing the subject line. Start
a new mail thread with the que
Hello Team,
Can you please let us know what postgre version is compatible with RHEL7.5? We
are currently using Postgre version 9.6.6.
DEEPTI SHARMA
Specialist
ITIL 2011 Foundation Certified
BDGS, R&D
Ericsson
3rd Floor, ASF Insignia - Block B Kings Canyon,
Gwal Pahari, Gurgaon, Haryana 122
On 05/21/2018 07:18 PM, Jonatan Evald Buus wrote:
> Hi there,
>
> I'm trying to configure streaming replication between a Red Hat server
> running PostGreSQL 9.2.2 and a Debian server running PostGreSQL 9.2.24
> with Hot Standby enabled.
>
> While the base backup works fine using /pg_basebackup/,
Hi there,
I'm trying to configure streaming replication between a Red Hat server
running PostGreSQL 9.2.2 and a Debian server running PostGreSQL 9.2.24 with
Hot Standby enabled.
While the base backup works fine using *pg_basebackup*, I get the following
errors with hot standby enabled on the Debi
34 matches
Mail list logo