On Tue, Sep 23, 2014 at 9:24 PM, Bill Moran wmo...@potentialtech.com
wrote:
On Tue, 23 Sep 2014 14:12:22 +0200
Thomas Kellerer spam_ea...@gmx.net wrote:
Sameer Kumar schrieb am 23.09.2014 um 07:24:
I am working with a vendor and planning to deploy their application
on PostgreSQL as
On Fri, Sep 19, 2014 at 1:23 PM, Dev Kumkar devdas.kum...@gmail.com wrote:
Apologies for the delay, was working/troubleshooting same issue and was
away from my emails. :(
Regards...
Received the database with huge pg_multixact directory of size 21G and
there are ~82,000 files in
--
Derek Giri
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi All,
I have Postgres 9.3 on Ubuntu 14.04 set up in a master/slave
configuration with streaming replication. On the master I ran `sudo
service postgresql stop` and then on the slave I ran `sudo touch
$trigger_file`. Now the slave seems to be running fine, but I'm trying
to figure out the
A bit more info:
What if there were changes on the master that didn't get replicated
before I originally shut it down?
It looks like Ubuntu's init.d script does a fast shutdown, i.e.
SIGINT on this page:
http://www.postgresql.org/docs/9.3/static/server-shutdown.html
I can't tell from the doc
Hi,
I am using version 9.3.1 and see the no space device error even though there
is enough space (99% free) on my disk.
Error: PANIC: could not create file pg_xlog/xlogtemp.7884: No space left on
device
I want to know whether this is a bug and if yes whether fix or workaround is
available.
On 25/09/2014 11:44, Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
Hi,
I am using version 9.3.1 and see the “no space device error” even though
there is enough space (99% free) on my disk.
Error: PANIC: could not create file pg_xlog/xlogtemp.7884: No space
left on device
On 25/09/2014 11:44, Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
Hi,
I am using version 9.3.1 and see the “no space device error” even though
there is enough space (99% free) on my disk.
Error: PANIC: could not create file pg_xlog/xlogtemp.7884: No space
left on device
Roopeshakumar Narayansa Shalgar (rshalgar) wrote
bash-3.2# du -h
4.0K./pg_stat
6.2M./base/12026
198M./base/16384
6.3M./base/12031
6.3M./base/1
216M./base
24K ./pg_stat_tmp
[...]
129M./pg_xlog
4.0K./pg_tblspc
12K ./pg_notify
4.0K./pg_twophase
Hello all,
I am setting up a streaming replication stand-by, and the replication role
password has a single quote in it. I am unable to properly reference the
password in the conninfo setting of recovery.conf so it will authenticate
to the master. Doubling the quote gives me a syntax error, and
On 09/26/14 12:58, Nelson Green wrote:
I am setting up a streaming replication stand-by, and the replication
role password has a single quote in it. I am unable to properly
reference the password in the conninfo setting of recovery.conf so it
will authenticate to the master. Doubling the
I have a growing database with millions of rows that track resources against an
event stream.
i have a few handfuls of queries that interact with this stream in a variety of
ways, and I have managed to drop things down from 70s to 3.5s on full scans and
offer .05s partial scans.
no
On 27/09/14 09:02, Jonathan Vanasco wrote:
I have a growing database with millions of rows that track resources against an
event stream.
i have a few handfuls of queries that interact with this stream in a variety of
ways, and I have managed to drop things down from 70s to 3.5s on full scans
Hi!
Have you tried escape the Single or Double quote? Maybe this information can
help you:
http://stackoverflow.com/questions/12316953/insert-varchar-with-single-quotes-in-postgresql
http://www.postgresql.org/docs/9.1/static/sql-syntax-lexical.html
Best Regards!
-
Dame un poco de fe,
We have a similar timeseries database approaching 500m records.
We partition the main tables (much like your events) into one year subsets,
with a clustered index on timestamp for all but the live year.
https://blog.engineyard.com/2013/scaling-postgresql-performance-table-partitioning
On 09/26/2014 12:58 PM, Nelson Green wrote:
Hello all,
I am setting up a streaming replication stand-by, and the replication
role password has a single quote in it. I am unable to properly
reference the password in the conninfo setting of recovery.conf so it
will authenticate to the master.
On Fri, Sep 26, 2014 at 5:51 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 09/26/2014 12:58 PM, Nelson Green wrote:
Hello all,
I am setting up a streaming replication stand-by, and the replication
role password has a single quote in it. I am unable to properly
reference the
On 9/26/2014 4:32 PM, Nelson Green wrote:
Thanks Bosco, DrakoRod, and Adrian. Between the three of you it became
obvious
that I was doing something wrong. And yes, in the end you were right.
Doubling
the quote does indeed work.
It turns out it this particular password also had a \ in it,
On 09/26/2014 04:32 PM, Nelson Green wrote:
On Fri, Sep 26, 2014 at 5:51 PM, Adrian Klaver
Doubling the quote seems to work here.
Thanks Bosco, DrakoRod, and Adrian. Between the three of you it became
obvious
that I was doing something wrong. And yes, in the end you were right.
Doubling
On 9/26/2014 4:40 PM, John R Pierce wrote:
I'd consider using `mkpasswd -l 15 -s 0` just to avoid any such
problems. 15 random alphanumerics is already plenty complex, 62^15th
possible combinations, without needing to mix in special characters.
$ mkpasswd -l 15 -s 0
eec1kj7ZsthlYmh
btw,
On 27/09/14 11:56, John R Pierce wrote:
On 9/26/2014 4:40 PM, John R Pierce wrote:
I'd consider using `mkpasswd -l 15 -s 0` just to avoid any such
problems. 15 random alphanumerics is already plenty complex,
62^15th possible combinations, without needing to mix in special
characters.
$
ex. avg(value) over (order by date range interval '6' day preceding)
Source:
http://wwwlgis.informatik.uni-kl.de/cms/fileadmin/courses/SS2008/NEDM/RDDM.Chapter.06.Windows_and_Query_Functions_in_SQL.pdf
Page 9, slide 17
The SELECT SQL command page mentions standard aspects of window frame
David G Johnston david.g.johns...@gmail.com writes:
Just looking for recollection regarding why these were omitted initially and
if anyone has concerned adding them in follow-up.
My recollection is that RANGE requires some data-type-specific behavior
that we don't have any provision for in PG's
23 matches
Mail list logo