Hi
2015-03-06 7:23 GMT+01:00 Alan Nilsson :
> Is it possible to use streaming replication across different platforms
> (OSX/linux)?
>
No, it is not possible - you have to use logical replication like Slony
Regards
Pavel Stehule
>
> As I read it, you must use a file system level base backup t
Is it possible to use streaming replication across different platforms
(OSX/linux)?
As I read it, you must use a file system level base backup to setup the slave.
I ran into problems trying pg_basebackup and, as was pointed out, that is not
supported. So will a tarball or any other file syste
On 3/5/2015 8:34 PM, Medhavi Mahansaria wrote:
I need to enter the date in null column based on the results obtained.
but my date gets inserted as 01/01/0001 in postgresql 9.3 when there
is no value.
I need to enter NULL in the column.
umm, it seems to work fine for me?you give us no
Hi,
I need to enter the date in null column based on the results obtained.
but my date gets inserted as 01/01/0001 in postgresql 9.3 when there is no
value.
I need to enter NULL in the column.
can anyone please help me out.
Its urgent.
Thanks in advance.
Regards
Medhavi Mahansaria
Tata Con
On 3/5/15 7:36 PM, wambacher wrote:
Jim Nasby-5 wrote
>On 3/5/15 2:06 PM, wambacher wrote:
>Crashed? Or hit by the OOM killer? What's the log say?
killed by OOM, but has only 1.2 GB mem, which is ok to me.
Ok, but...
>What's the largest memory size that a vacuum/autovac against that table
>
Jim Nasby-5 wrote
> On 3/5/15 2:06 PM, wambacher wrote:
> Crashed? Or hit by the OOM killer? What's the log say?
killed by OOM, but has only 1.2 GB mem, which is ok to me.
> While this is going on you might as well disable autovac for that table.
> It'll keep crashing and will interfere with yo
Steven Erickson wrote
> My problem now is that SELECTs scan all child tables
And what do these SELECTs look like - specifically the WHERE clauses?
David J.
--
View this message in context:
http://postgresql.nabble.com/Constraints-and-inheritance-tp5840715p5840716.html
Sent from the PostgreS
I have a table that has over 100K rows of GIS data, including a raster and an
insertdatetime timestamp columns. This table is continually loaded with data
with processes on the back side querying the data and populating other tables
depending on characteristics of the data. Today a row is rea
On 3/5/15 2:06 PM, wambacher wrote:
crashed:
no idea what to do now.
Crashed? Or hit by the OOM killer? What's the log say?
While this is going on you might as well disable autovac for that table.
It'll keep crashing and will interfere with your manual vacuums.
It sounds at this point like
crashed:
no idea what to do now.
walter
--
View this message in context:
http://postgresql.nabble.com/autovacuum-worker-running-amok-and-me-too-tp5840299p5840696.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-genera
Thanks.
On Wed, Mar 4, 2015 at 10:22 PM, John R Pierce wrote:
> On 3/4/2015 9:10 PM, AI Rumman wrote:
>
>> I am working on setting up a new database server with shared disk and
>> cluster failover.
>> In this environment, only one node will be active at a certain time.
>> Underneath, we are plan
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 stor
> ... this will need some hours.
Done after 30 Minutes :)
nearly 50% dead rows - strange.
Now i'll run a "vacuum verbose planet_osm_ways" because the system crashed
during the autovacuum.
cross my fingers.
Walter
--
View this message in context:
http://postgresql.nabble.com/autovacuum-
On 3/5/15 1:05 PM, Adrian Klaver wrote:
Is there any reason why Postgresql does not implement the SQL standard's
version of GLOBAL temporary tables?
Because no one has gotten around to it. There's been discussion about it
(search the pgsql-hackers archives).
I also don't like the idea of pa
Hi,
in my first post you can see all params:
maintenance_work_mem = 64MB and two workers. i configured my system to the
absolutely minimum ( got 24 GB real memory) and the problem was still
there.
Last night i rebuilt one index (122GB Size) and just in this minutes i
started a manual "analyze
On 03/05/2015 11:01 AM, Igor Neyman wrote:
Sorry, my reply was based on (old) Oracle knowledge.
Now, I'm wondering too, why PG didn't implement such basic (at least to
me) feature.
Per my previous post, see:
http://www.postgresql.org/docs/9.4/interactive/sql-createtable.html
Compatibility
On 03/05/2015 07:37 AM, inspector morse wrote:
I'm confused with what Igor said. He said to create the temporary table
with "on commit preseve rows" but in the documentation it states that
when a session ends (like after each request in a web application when
not using persistent connections), th
> > Sorry, my reply was based on (old) Oracle knowledge.
> > Now, I'm wondering too, why PG didn't implement such basic (at least to
> me) feature.
>
> Per my previous post, see:
>
> http://www.postgresql.org/docs/9.4/interactive/sql-createtable.html
>
> Compatibility
>
> The CREATE TABLE com
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'm confuse
Hi Francisco,
thanks!
The solution with
(cat q2.sql; psql -h host1 -U user1 -d db1 -f /q1.sql) | psql -h host2 -U
user2 -d db2
worked! First I have forgotten the semicolon at the end of q2.sql and got an
error.
Tim
Von: Francisco Olarte [mailto:fola...@peoplecall.com]
Gese
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'm confused with what Igor said. He said to create the
* pinker (pin...@onet.eu) wrote:
> You have spam on postgresql.org main page...
> "Jim Smith: Myśli o istotnych Szczegóły kwiatów dostawy online"
> It's not even proper polish :)
Fixed that, sorry for not realising it earlier. We saw it on the planet
side pretty quickly, just missed that it also
Sam,
* Samuel Smith (pg...@net153.net) wrote:
> Does anyone know if there is a wishlist item for improving this in
> postgresql or is this as good as it gets for now?
It's absolutely on the todo list for PG to support declarative
partitioning and handle these cases better. There has been a good
I'm confused with what Igor said. He said to create the temporary table
with "on commit preseve rows" but in the documentation it states that when
a session ends (like after each request in a web application when not using
persistent connections), the temporary table would automatically be dropped.
On 03/05/2015 07:10 AM, Merlin Moncure wrote:
On Thu, Mar 5, 2015 at 8:58 AM, Igor Neyman wrote:
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of inspector morse
Sent: Thursday, March 05, 2015 9:21 AM
To: pgsql-general@postgresql.org
Subject: [GE
On Thu, Mar 5, 2015 at 8:58 AM, Igor Neyman wrote:
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of inspector morse
> Sent: Thursday, March 05, 2015 9:21 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Sharing data between stored func
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of inspector morse
Sent: Thursday, March 05, 2015 9:21 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Sharing data between stored functions?
I have written a simple web application using pure
wambacher wrote:
> watching the memory usage of the autovaccum process: is was getting bigger
> and bigger at nearly constant speed. some MB per minute, iir.
What are your settings for maintenance_work_mem and autovacuum_max_workers?
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The En
On 03/04/2015 12:11 AM, David G Johnston wrote:
In short - since the planner determines exclusion constraints and the
executor, which strictly follows the planner in the query execution process,
would be the one to determine what the value of your date is - there is no
way for a single query to
Whithout -E there was the same error.
The DB was create with:
create database "davical" WITH ENCODING = 'UTF8' LC_CTYPE='en_US.utf8'
LC_COLLATE='en_US.utf8' TEMPLATE template0;
I have fix the error with
localedef -f UTF-8 -i en_US en_US.UTF-8
After a restart of postgres all is fine.
Thanks a
I have written a simple web application using pure pl/pgsql and so far it
is working really well (I find it quite easy to maintain as well especially
in terms of form validation).
Basically, apache/php passes receives the incoming web request and calls a
"serve_page" function in postgresql passing
On 03/05/2015 02:48 AM, basti wrote:
Hello I have a postgres cluster with following databases
davical| pgadmin | UTF8 | en_US.utf8 |
en_US.utf8 |
test| test | LATIN9| en_US.iso885915 |
en_US.iso885915 |
foo
Hello I have a postgres cluster with following databases
davical| pgadmin | UTF8 | en_US.utf8 |
en_US.utf8 |
test| test | LATIN9| en_US.iso885915 |
en_US.iso885915 |
foo| postgres | SQL_ASCII | en_US.
I got the query plan using:
EXECUTE EXPLAIN (format json) ... INTO query_plan;
RAISE NOTICE query_plan;
since by default EXPLAIN returns a set of rows and I'd have to create a
table for storing that. As I mentioned in the original email,
the queries and output is nicely formatted at:
http://stack
On 3/3/15 8:18 AM, Tim Semmelhaack wrote:
When I run a much simpler version of the query with the -c "Select .."
option it works. Because the sql-scripts are quite long, I don't to do it
without the -f option.
When you say quite long... are you trying to do multiple commands in q1
or q2? As in
On 3/3/15 6:52 AM, hailong Li wrote:
Finally , I made a new slave instance on the slave server and it works
fine until now.
Just so you're aware, that error means there was page level corruption
either on the replica or possibly on the master, or the replication
stream or WAL files got cor
On 2/27/15 5:11 AM, Sergey Shchukin wrote:
show max_standby_streaming_delay;
max_standby_streaming_delay
-
30s
We both need to be more clear about which server we're talking about
(master or replica).
What are max_standby_streaming_delay and max_standby_archi
37 matches
Mail list logo
