ive it to
you.
So what sort of replication(streaming, archiving, synchronous,etc) where
you doing?
Was the streaming happening across a local network or a remote network?
Was there a hardware issue on either of the machines?
Thanks
Best Regards!
--
Adrian Klaver
adrian.kla...@aklave
ved logs i'd be
able to recover.
Was I wrong with that assertion or did i just run into a bug?
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
from file in postgres
any help..?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
h host2 -U user2 -d db2
< /q2.sql
So where is the difference between the -c and the -f option?
Tim
-- Semmelhaack(at)gmx(dot).de
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 03/03/2015 10:09 AM, Francisco Olarte wrote:
Hi Adrian:
On Tue, Mar 3, 2015 at 4:44 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote:
On 03/03/2015 06:18 AM, Tim Semmelhaack wrote:
Hi,
I want to copy data between two servers (Version 9.1 a
What happens if you do not use -E?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
effect. Use of these keywords is discouraged, since future versions of
PostgreSQL might adopt a more standard-compliant interpretation of their
meaning.
"
In plpgsql, it's also possible to maintain state by keeping it in
things like arrays of records that you pass around. In the futu
On 03/05/2015 07:48 AM, Igor Neyman wrote:
From: inspector morse [mailto:inspectormors...@gmail.com]
Sent: Thursday, March 05, 2015 10:37 AM
To: Adrian Klaver
Cc: Merlin Moncure; Igor Neyman; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sharing data between stored functions?
I&#
d borrow from them.
On Thu, Mar 5, 2015 at 10:18 AM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 03/05/2015 07:10 AM, Merlin Moncure wrote:
On Thu, Mar 5, 2015 at 8:58 AM, Igor Neyman
mailto:iney...@perceptron.com>> wrote:
patibility
The CREATE TABLE command conforms to the SQL standard, with exceptions
listed below.
Temporary Tables
Regards,
Igor Neyman
--
Adrian Klaver
adrian.kla...@aklaver.com
m.b. I'm missing something, but this quote from docs doesn't explain "why", it
j
On 03/05/2015 11:20 AM, Igor Neyman wrote:
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Thursday, March 05, 2015 2:07 PM
To: Igor Neyman; inspector morse
Cc: Merlin Moncure; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sharing data between
e it takes to do the SELECT and process the COMMIT.
Do you want the lock to hold past the COMMIT?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
when it's time to do it there. Dump-and-restore definitely
does not meet that requirement, even if it does eventually recreate a
working database.
Any ideas? I'm sure I'm missing something obvious, here, but I can't
seem to find any reference that tells me what it would be.
On 03/06/2015 10:35 AM, Stephen Frost wrote:
Adrian,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
On 03/06/2015 10:11 AM, Matt Landry wrote:
Attempting to upgrade a large (>3TB) postgressql database from 9.3 to
9.4 on Ubuntu 14.04 LTS, but the process fails fairly early on. The
er
On 03/06/2015 11:22 AM, Matt Landry wrote:
On 03/06/2015 12:37 PM, Adrian Klaver wrote:
Agreed, I am just trying to figure out how you get:
CREATE DATABASE "template0" WITH TEMPLATE = template0 ..
Seems to be a snake eating its tail:)
Yes. It does. And it's pretty obvious
On 03/06/2015 11:22 AM, Matt Landry wrote:
On 03/06/2015 12:37 PM, Adrian Klaver wrote:
Agreed, I am just trying to figure out how you get:
CREATE DATABASE "template0" WITH TEMPLATE = template0 ..
Seems to be a snake eating its tail:)
Yes. It does. And it's pretty obvious
dvice will be greatly appreciated.
How was Postgres installed?
What where you doing to get the error?
Doing a pg_restore from another database?
Running CREATE LANGUAGE/EXTENSION directly?
Diana
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgs
preciated.
How was Postgres installed?
What where you doing to get the error?
Doing a pg_restore from another database?
Running CREATE LANGUAGE/EXTENSION directly?
Diana
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general
on OS X so I am probably not the best person to guide
you through this. Hopefully someone with more experience can step in and
offer further assistance.
Diana
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
ed with Postgres.app,
see the section on Command Line Tools."
Or I must first install postgres 9.3 by other means and only after that I
can use PostgresApp for an easier access to postgres?
No.
Confused,
Diana
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general ma
you,
Diana
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
reduce-table-size-tp5840782p5841085.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
be able to offer.
Best!
Eli Murray
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
07s/1.56u sec elapsed 3.24 sec.
Query returned successfully with no result in 6436 ms.
PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.2
20140120 (Red Hat 4.8.2-16), 64-bit
It was flash copy snapshot
So what does that mean?
In other words detail the steps you took to get t
On 03/09/2015 07:37 AM, pinker wrote:
Adrian Klaver-4 wrote
On 03/09/2015 07:08 AM, pinker wrote:
I did: select pg_cancel_backend(pid) from pg_stat_activity where usename
<>
'mine';
What makes you think that queries from usename = 'mine' are not important?
Because
rocess needs to be spelled out.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
And that number is an increase from the original number
which was 2989662 nonremovable row versions.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@post
particular connection such as host ip address and then use that create
a new connection to a different database.
Well you say you are using tcl, so you will need to elaborate on what
that means?
What library are you using?
Thank You
Anushka
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/09/2015 09:19 AM, Joshua D. Drake wrote:
On 03/09/2015 08:57 AM, Adrian Klaver wrote:
On 03/09/2015 08:49 AM, Kevin Grittner wrote:
pinker wrote:
INFO: vacuuming "my_table"
INFO: "my_table": found 0 removable, 3043947 nonremovable row
versions in 37580 pages
9, 2015 at 11:00 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 03/09/2015 09:52 AM, Anushka Chandrababu wrote:
Hi,
I am using Postgres as a part of another software and the
version is 9.3.
That software would be?
I do not know ho
hows and whys see this thread :
http://www.postgresql.org/message-id/4d6bb33f.9010...@lupomesky.cz
Thanks,
Stephen
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/11/2015 08:52 AM, pinker wrote:
Adrian Klaver-4 wrote
Also per Kevin Grittner and Tom Lane there
is a Nabble issue at work where the list here is not seeing all the
information. Example:
It's because I edited some post. Then is visible only on nabble because
edited version isn&#
when the constraint is introduced.
On Tue, Mar 10, 2015 at 10:16 AM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 03/10/2015 05:41 AM, Stephen Frost wrote:
* Andrzej Pilacik (cypise...@gmail.com
<mailto:cypise...@gmail.com>) wrote:
but i noticed it is not specified.
Without some concrete information this will difficult to answer.
1) How many is lots?
2) Why do you need static connections?
3) What are the hardware specifications for your machine?
Thank you,
Francesco
--
Adrian Klaver
adrian.kla...@aklaver.com
Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7293
-------
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/16/2015 04:16 PM, Israel Brewster wrote:
On Mar 16, 2015, at 2:22 PM, David G. Johnston
mailto:david.g.johns...@gmail.com>> wrote:
On Mon, Mar 16, 2015 at 3:13 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>>wrote:
On 03/16/2015 02:57 PM, Israel Brewster wrote:
diately and permanently delete the message
and any attachments. Thank you
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
with. Take a look at:
http://www.postgresql.org/docs/9.3/interactive/plpgsql-errors-and-messages.html
Also might want to look at:
http://www.postgresql.org/docs/9.3/interactive/plpgsql-porting.html
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-ge
t.
---
Israel Brewster
Systems Analyst II
Ravn Alaska
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7293
---
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general
--
Adrian Klaver
adrian.kla...@aklaver.com
On Tue, Mar 17, 2015, at 11:30 AM, Adrian Klaver wrote:
> On 03/17/2015 10:57 AM, Israel Brewster wrote:
> >
> >
> >> On Mar 17, 2015, at 9:30 AM, Paul Jungwirth
> >> wrote:
> >>
> >> So nex
l recovery.conf in the output directory (or into the
base archive file when using tar format) to ease setting up a standby
server.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
and all related objects to the table to be excluded are not
dumpled, but why I don't get any CREATE SEQUENCE command in my dump?.
What version of Postgres?
If I follow you have CREATEd sequence(s) using CREATE SEQUENCE and they
do not show up in the dump file?
It works for me here on 9.3
On 03/19/2015 10:02 AM, "Leonardo M. Ramé" wrote:
El 19/03/15 a las 13:09, Adrian Klaver escibió:
On 03/19/2015 08:43 AM, "Leonardo M. Ramé" wrote:
Hi, I'm creating a database dump excluding one table and found only the
sequences created implicitly (using serial
93p5842524.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I am not sure what the exact issue is?
How are you determining that the new time zone is not being used?
What was the old time zone, what is the new one?
Leonardo.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On 03/20/2015 10:21 AM, "Leonardo M. Ramé" wrote:
El 19/03/15 a las 14:13, Adrian Klaver escibió:
On 03/19/2015 10:02 AM, "Leonardo M. Ramé" wrote:
El 19/03/15 a las 13:09, Adrian Klaver escibió:
On 03/19/2015 08:43 AM, "Leonardo M. Ramé" wrote:
Hi, I'm
ity statement as a string and EXECUTE it."
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in the CSV file? - if so, delete it and try again.
If it is not a header row issue then it could be the columns in the CSV
file do not match the columns in the table and that data is not matching
what the table column expects. You can specify a column list in the COPY.
Ray.
--
Adrian Klaver
y and they are fine.
Many thanks
R Clarke
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
when
export/import/update, i must excute query on alot of table. And this way
lead data to inconsistency if I forget update/export/import on 1 or more
table. It is terrible.
@John
I will learing about it. Thanks alot.
@All: If you have any suggestion, please let me known. Thanks for you help
jointes.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
one from table B.
Best Regards,
Steve
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
y the db doesn't recognize the name of the table without quotes?.
See here, bottom of 4.1.1. Identifiers and Key Words:
http://www.postgresql.org/docs/9.3/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
Regards,
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pg
On 03/26/2015 10:21 AM, "Leonardo M. Ramé" wrote:
El 26/03/15 a las 14:18, Adrian Klaver escibió:
On 03/26/2015 10:12 AM, "Leonardo M. Ramé" wrote:
Ok, I have this table:
CREATE TABLE sessions
(
"SESSIONID" integer NOT NULL,
"SESSIONTIMEST
.
Does anyone know the proper syntax to create an array of JSON objects
from an existing table?
json_build_array?
http://www.postgresql.org/docs/9.4/interactive/functions-json.html
--
Senior Web Developer at The Daily Illini
ejmur...@illinimedia.com <mailto:ejmur...@illinimedia.com>
(8
values ('fld1_test2', 'fld1_test2');
postgres@test=# select row_to_json(row(fld_1, fld_2)) from
build_object_test;
row_to_json
-----------
{"f1":"fld1_test1","f2":"fld1_test1"}
{"f1":"fld1_te
duck debug off
of you.
Second cut:
postgres@test=# select array_to_json(array_agg(row(fld_1, fld_2))) from
build_object_test;
array_to_json
---
[{"f1":"fld1_test1",&
s because of fields names with reserved words. I
was wondering if there is a way to "alias" a field name when
creating the foreign table?
Thanks in advance!!!
Deven
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-
al@postgresql.org
<mailto:pgsql-general@postgresql.org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Senior Web Developer at The Daily Illini
ejmur...@illinimedia.com <mailto:ejmur...@illinimedia.com>
(815) 985-8760
--
Adri
h the settings above.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/27/2015 03:04 PM, Deven Phillips wrote:
OK, one of the devs on the GitHub page for that FDW helped me realize
that I had accidentally mapped the wrong table! Doh!
Me looks back. Oops, missed that.
Deven
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing
d tool, it just does not fit my way of
working.
Thank you for reading thus far.
Yuri Budilov
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
kshit
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
point me to some useful resources on this.
I would start here:
http://www.postgresql.org/docs/9.4/interactive/sql-createoperator.html
http://www.postgresql.org/developer/coding/
Thanks and Regards,
Danushka
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list
pi.python.org/pypi/dbf/0.88.16) and do the comparisons
in the DBF files outside Postgres and only import what has changed.
Thanks a lot for your help!
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
.
Line feeds will be added between level-1 elements if
^^^
pretty_bool is true.
I would say post a feature request on --hackers or at ask if work is
being done on this.
Thanks in advance!
Deven
--
Adrian Klaver
adrian.kla...@aklave
DBF files.
Thanks.
2015-03-30 9:53 GMT-04:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>:
On 03/30/2015 06:04 AM, Guillaume Drolet wrote:
Hello,
I need your help speeding up the procedure I will explain below.
I am
looking for improvements
On 03/29/2015 08:52 PM, Maulik Shah wrote:
Dear Sir/Madam
how to convert float to timestamp in single select query
for exp. i have float as 1.251152515236 ,
test=> select to_timestamp(1.251152515236);
to_timestamp
---
1969-12-31 16:00:01.251153-08
The
http://www.enterprisedb.com/docs/en/9.3/pginstguide/Table%20of%20Contents.htm
4 Using Stack Builder
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
install Postgres and what OS?
On Wed, Apr 1, 2015 at 7:15 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote:
On 04/01/2015 06:22 AM, Ramesh T wrote:
Hi all,
I didn't selected stack builder at the time of
installation
of postgr
On 04/01/2015 08:21 AM, Ramesh T wrote:
I had installed on Linux.re-install postgres for stack builder ..?
cron is their ,but I am new to this cron and is this method for job
schedulers in postgres.
Again, how did you install Postgres?
On Wed, Apr 1, 2015 at 8:39 PM, Adrian Klaver
at has a varchar field for the date
data and then do a conversion and transfer to the final table.
Thanks!
Geoff
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
without
time zone - 'epoch'));
?column?
-
1970-01-01 00:00:00
Or:
test=> select now() - extract('epoch' from (now() -
'epoch'::timestamptz)) * interval '1 sec';
?column?
1969-12-
.postgresql.org/docs/9.4/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN:
EXECUTE 'insert into ' || quote_ident(tblname) || ' values(' || new.* || ')'
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgs
On 04/02/2015 09:59 PM, Scott Ribe wrote:
On Apr 2, 2015, at 10:14 PM, Adrian Klaver wrote:
EXECUTE 'insert into ' || quote_ident(tblname) || ' values(' || new.* || ')'
Not that easy, strings are not quoted correctly, and null values are blank.
Might be a func
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
pment this
application.
What languages are you comfortable with?
Seems from the above the UI is separate from the application, is that
the case?
Is so what is the application written in?
Thanks in advance.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing
ough in the event of list issues.
On Sun, Apr 5, 2015 at 1:35 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote:
On 04/05/2015 01:21 PM, Ray Madigan wrote:
I have been using postgresql in java off and on for many years.
I now
have an assignemtn wh
e just doing a substitution.
They both do string interpolation but one is significantly faster than
the other. Is there a third and even faster way?
I am using RDS so I can't really do stored procs in C.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing l
correctly:
http://www.postgresql.org/docs/9.4/interactive/ecpg-variables.html
--
Cheers,
Andrew Pennebaker
www.yellosoft.us <http://www.yellosoft.us>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
still have not explored where the Postgres in your containers are coming
from and how they are set up in image: mdillon/postgis:9.3.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ht
ts.html#PG-STAT-REPLICATION-VIEW
I am almost positive that somewhere in the switch from --single mode to
regular mode information is being lost.
--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
S
erver is saying it is not finding:
pg_xlog/00010013
and it is switching the WAL source back and forth from a WAL archive to
streaming looking for it.
Just to be sure is actually not there on the standby?
Is still in the pg_xlog directory on the primary?
--
Adrian Klaver
adria
much happening at one time to
get a clear picture of what is going on.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
0001000C.0028.backup
0001000D
0001000E
archive_status
--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-g
t;http://bit.ly/1h1ebjy>
--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
even being made.
On Thu, Apr 9, 2015 at 4:32 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote:
On 04/09/2015 01:14 PM, Volkan Unsal wrote:
Oops. I used a dummy IP address in the yml file for privacy
reasons. The
actual IP addresses would be placed t
in your primary server directory?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
regards, tom lane
--
Cheers,
Andrew Pennebaker
www.yellosoft.us <http://www.yellosoft.us>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
b.com/markdrago/pgsanity/blob/master/pgsanity/sqlprep.py
which is where the passed in SQL string is processed into ecpg format
does not show that it deals with variables. So you might to take this up
with the pgsanity author.
On Wed, Apr 8, 2015 at 9:34 AM, Adrian Klaver mailto:adrian.kla...@akla
sal/ad2173e2649393fcd3b6#file-init-slave-sh-L32-L36>.
Yes, I saw that, but have you checked the primary $PGDATA anyway?
--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (p
mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
| Attributes | Member of
---+-+---
rep_user | Replication | {}
Also what file do you have primary_conninfo in?
--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via
atabase listening on?
http://www.postgresql.org/docs/9.4/interactive/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS
listen_addresses (string)
Can you connect remotely from the standby using psql?
--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http:
lkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
recovery state reached at 0/EF0
On Thu, Apr 9, 2015 at 4:51 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote:
On 04/09/2015 01:48 PM, Volkan Unsal wrote:
HI Adrian,
Is there a chance you have a recovery.conf in your primary
p://bit.ly/1h1ebjy>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.com> <http://bit.ly/1h1ebjy>
>
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>
--
Adr
1 - 100 of 4920 matches
Mail list logo
