On 18 April 2016 at 13:10, Sergei Agalakov wrote:
> Thank you, I know this place.
> I just wanted to check that my request will have the peoples support.
> So far it doesn't. It looks like that or people never need to compare two PG
> databases to find the differences in the schemas or security,
>
I am attempting to create a new language implementation. The language is
Andl (andl.org), so the handler is plandl.
I am having a bit of trouble executing SPI queries from inside plandl.
The particular problem arises after calling SPI_cursor_fetch() and then
SPI_getbinval() on a column of type BY
On 16/04/16 14:00, Peter Devoy wrote:
Although people commonly use $foo $bar in examples, it is actually a misuse of
a VERY rude acronym.
The next time you need to make an example, please try being a little more
original (or meaningful) with your variable names.
In light of recent CoC decision
Thank you, I know this place.
I just wanted to check that my request will have the peoples support.
So far it doesn't. It looks like that or people never need to compare
two PG databases to find the differences in the schemas or security,
or happy to use the third party tools to do it, and don't
Nobody asks for pg_dump to be a schema comparison tool. As you tell
yourself
it is a most reliable schema capturing tool. All I am asking is that if
pg_dump is executed
on two databases with the identical schemas and security it should be
able to produce
the identical SQL dumps of these schemas
fyi, if you have a feature request or enhancement, then the proper place
for that is here -> https://postgresql.uservoice.com/forums/21853-general
On Sun, Apr 17, 2016 at 8:26 PM, Sergei Agalakov <
sergei.agala...@getmyle.com> wrote:
> I hardly can see that a sorting of the grants by users will
I hardly can see that a sorting of the grants by users will create a
measurable impact on the pg_dump performance in a real database.
One can imaging a database with tens of thousands of objects and tens of
thousands of users and almost no data, but it would be quite unusual.
Anyway, if a sorting
On 4/17/2016 3:21 PM, drum.lu...@gmail.com wrote:
Can I use the same SAN array to a Master and a Slave server?
as long as they are different logical volumes on the SAN, sure. of
course that SAN will be dealing with the IO load from both servers, and
the SAN itself could be a single point of
Hi all,
Currently, I have four servers:
- 1 Master server
- 1 Slave server (read-only)
- 2 Slaves servers (hot_standby)
We're having I/O and size issue, currently running SATA disks.
So we'll need to change our disks to SAN.
*Question:*
Can I use the same SAN array to a Master and
On 04/17/2016 01:58 PM, Adrian Klaver wrote:
On 04/17/2016 01:10 PM, Sergei Agalakov wrote:
I don't see how these questions are related to the proposed pg_dump
improvement.
I suggest to improve pg_dump so it can be used instead of the third
party tools like DBSteward and SQLWorkbench/J etc.
to c
On 04/17/2016 01:10 PM, Sergei Agalakov wrote:
I don't see how these questions are related to the proposed pg_dump
improvement.
I suggest to improve pg_dump so it can be used instead of the third
party tools like DBSteward and SQLWorkbench/J etc.
to compare two different databases or existing dum
On 04/17/2016 01:10 PM, Sergei Agalakov wrote:
I don't see how these questions are related to the proposed pg_dump
improvement.
I suggest to improve pg_dump so it can be used instead of the third
party tools like DBSteward and SQLWorkbench/J etc.
to compare two different databases or existing dum
On Sun, 17 Apr 2016 14:10:50 -0600
Sergei Agalakov wrote:
> I don't see how these questions are related to the proposed pg_dump
> improvement.
> I suggest to improve pg_dump so it can be used instead of the third
> party tools like DBSteward and SQLWorkbench/J etc.
> to compare two different da
I don't see how these questions are related to the proposed pg_dump
improvement.
I suggest to improve pg_dump so it can be used instead of the third
party tools like DBSteward and SQLWorkbench/J etc.
to compare two different databases or existing dumps, and to identify
the differences. The use c
Hello Adrian,
I tried to use -U without "su"- launched directly by root: same behaviour.
Finally I reverted my script to use standard backup (pg_start_backup;
rsync; pg_stop_backup)- this works- the only downside is possible
collisions with on-line backup/synchronizaiton of other two nodes on mast
> On Apr 17, 2016, at 12:41 PM, Sergei Agalakov
> wrote:
>
> I know about DBSteward. I don't like to bring PHP infrastructure only to be
> able to compare two dumps,
> and to deal with potential bugs in the third party tools. The pg_dump in
> other hand is always here, and is always trusted.
I know about DBSteward. I don't like to bring PHP infrastructure only to
be able to compare two dumps,
and to deal with potential bugs in the third party tools. The pg_dump in
other hand is always here, and is always trusted.
SQLWorkbench/J also can compare two schemas, and requires only Java.
A
It can be done of course, but as you can see in my examples the
statements in pg_dump generated scripts are grouped together by the objects.
It is easier to analyze the differences when all these differences for
an object are clustered together, and aren't dispersed in the diff file.
It also wil
On Sat, 16 Apr 2016 13:33:21 -0600
Sergei Agalakov wrote:
> Hi,
>
> Currently as in PG 9.4, 9.5 the order of the statements in the script
> produced by pg_dump is uncertain even for the same versions of the
> databases and pg_dump.
> One database may script grants like
>
> REVOKE ALL ON TABLE
On 04/15/2016 04:35 PM, Melvin Davidson wrote:
*Although people commonly use $foo $bar in examples, it is actually a
misuse of a VERY rude acronym.
Actually it isn't.
*The next time you need to make an example, please try being a little
more original (or meaningful) with your variable names.
On 14 April 2016 at 17:11, Moreno Andreo wrote:
> All databases that have to be replicated have a flag in the app
> configuration, and the replication config is set up, for each database and
> each site, when the first synchronization is made, so we could spawn a
> process per database and repli
On 14 April 2016 at 17:14, konstantin knizhnik
wrote:
>
> On Apr 14, 2016, at 8:41 AM, Craig Ringer wrote:
>
> On 1 April 2016 at 19:50, Konstantin Knizhnik
> wrote:
>
> Right now the main problem is parallel apply: we need to apply changes
>> concurrently to avoid unintended dependencies causin
On Sat, Apr 16, 2016 at 01:33:21PM -0600, Sergei Agalakov wrote:
> Currently as in PG 9.4, 9.5 the order of the statements in the script
> produced by pg_dump is uncertain even for the same versions of the databases
> and pg_dump.
> One database may script grants like
>
> REVOKE ALL ON TABLE cont
Hi David,
How many different table/objects do you read from and do you use bind
variables?
Each postmaster process keeps internal dictionary on objects and queries
ran - If you have too many objects or queries planned you might take up too
much ram.
If this is indeed your situation, you might bene
Hi All,
The document said, "Read Committed mode starts each command with a new
snapshot that includes all transactions committed up to that instant".
But what about the embedded commands within the outer command itself?
Do they share the same snapshot with the outer command?
a) trigger
This is
25 matches
Mail list logo
