i want to recluster an immutable table without locking the table and
then add the table as a partition of a parent table. my plan was:
create table tbl_cpy as select * from tbl order by c1 asc;
alter table tbl_cpy add constraint c1 not null, c1>=lo c1i want this to run quickly. so, i popul
Pre-copying is not really an option since we could potentially need 1-X
instances so it needs to be scalable. XFS also allows for "cp --reflink"
which I could do on a PGDATA directory and then change the port number.
That's probably the method I'll try first.
We do use barman, but again a barman
Apologies for the low tech suggestion, but if this really is a clone of a
previously existing template, could the clone operation just be done ahead
of time? I.e., have the build server keep X copies ready for use and
generate additional copies as those are consumed, so that the cloning is no
longe
Kenneth Marshall writes:
> On Fri, Mar 01, 2019 at 11:57:30AM -0800, Kevin Wilkinson wrote:
>
>> if you are able/willing to use ZFS (rather than ext4, xfs, ...) to
>> store your database, then it might work for you. ZFS is
>> copy-on-write so it can very quickly clone a database.
>>
>> kevin
>
>
Greetings,
* Jean-Philippe Chenel (jp.che...@live.ca) wrote:
> Thank you very much for your help.
> I think I was missing an important command in the equation.
>
> sudo realm --verbose join ad.corp.com --user=Administrateur
> --user-principal=postgres/ubuntu.ad.corp@ad.corp.com
>
> The Li
Dear Stephen,
Thank you very much for your help.
I think I was missing an important command in the equation.
sudo realm --verbose join ad.corp.com --user=Administrateur
--user-principal=postgres/ubuntu.ad.corp@ad.corp.com
The Linux server as joint the AD and now, psql connection work ve
On 3/1/19 11:11 AM, Bill Haught wrote:
On 2/24/2019 12:05 PM, Bill Haught wrote:
I noticed that for 11.2, non-server versions of Windows are not listed
as supported platforms. Is support in the process of being dropped
for non-server editions of Windows when 10.7 is no longer supported
(appar
On Fri, Mar 01, 2019 at 11:57:30AM -0800, Kevin Wilkinson wrote:
> if you are able/willing to use ZFS (rather than ext4, xfs, ...) to
> store your database, then it might work for you. ZFS is
> copy-on-write so it can very quickly clone a database.
>
> kevin
Hi Arjun
Redhat 7 does have LVM snaps
if you are able/willing to use ZFS (rather than ext4, xfs, ...) to store
your database, then it might work for you. ZFS is copy-on-write so it
can very quickly clone a database.
kevin
On 3/1/2019 12:08 PM, Arjun Ranade wrote:
I'm working on a project that requires on-demand creation of a fresh
I'm working on a project that requires on-demand creation of a fresh
database as quick as possible (seconds). Essentially, this is a build
server that will require a cloned instance of Postgres to run unit tests
on. So the pattern of use would be:
- Build is triggered
- New postgres insta
On 2/24/2019 12:05 PM, Bill Haught wrote:
I noticed that for 11.2, non-server versions of Windows are not listed
as supported platforms. Is support in the process of being dropped for
non-server editions of Windows when 10.7 is no longer supported
(apparently years away though)? Or will such
Greetings,
* Jean-Philippe Chenel (jp.che...@live.ca) wrote:
> I'm trying to configure authentication between PostgreSQL database server on
> linux and Windows Active Directory.
>
> First part of configuration is working but when I'm trying to authenticate
> from Windows client, it is not worki
On 01/03/2019 15:01, Nicola Contu wrote:
Hello,
is there any reason why I am getting worse results using pgsql11.2 in
writing comparing it with pgsql 10.6?
I have two Instances, both just restored, so no bloats.
Running read queries I have pretty much same results, a little bit
better on pg11
JD, IB, TL:
Yes!!! I found the whole bunch of tables in template 1!
It's so liberating.
Thank you.
- Original Message -
> From: Tom Lane
> To: s4...@yahoo.co.jp
> Cc: "pgsql-general@lists.postgresql.org"
> Date: 2019/2/28, Thu 17:24
> Subject: Re: Mind of its own?
>
>& lt;s4...
Hello,
is there any reason why I am getting worse results using pgsql11.2 in
writing comparing it with pgsql 10.6?
I have two Instances, both just restored, so no bloats.
Running read queries I have pretty much same results, a little bit better
on pg11- Running writes the difference is in favour o
On Thu, Feb 28, 2019 at 6:24 AM Chris Travers wrote:
>
> On Thu, Feb 28, 2019 at 1:09 PM Pavel Stehule wrote:
>>
>> Hi
>>
>> čt 28. 2. 2019 v 12:47 odesílatel Thomas Güttler
>> napsal:
>>>
>>> Hi experts,
>>>
>>> where would you suggest someone to **not** use PostgreSQL?
>
>
> Hard question. T
Thank you very much for your friendly answers.
I added some parts to my guidlines:
https://github.com/guettli/programming-guidelines/blob/master/README.rst#where-to-not-use-postgresql
Feedback is welcome.
Regards,
Thomas Güttler
Am 28.02.19 um 12:47 schrieb Thomas Güttler:
Hi expert
Achilleas,
On 2/27/19 11:39 AM, Achilleas Mantzios wrote:
On 21/2/19 9:28 π.μ., Achilleas Mantzios wrote:
On 21/2/19 9:17 π.μ., Julie Nishimura wrote:
Does anyone use this solution? any recommenations?
Thanks!
Barman will fit most requirements. PgBackRest excels when WAL traffic
goes on 10
> "Ron" == Ron writes:
Ron> Arrays are -- by definition -- not atomic, and so they
Ron> fundamentally break the model that relational databases are
Ron> founded upon. If you want to be a good database designer, don't
Ron> use arrays.
"In theory there is no difference between theory and
On 3/1/19 1:37 AM, Adrian Klaver wrote:
On 2/28/19 12:28 PM, chiru r wrote:
The below steps we followed.
yum -y install perl-parent
yum -y install perl-Time-HiRes
yum -y install perl-JSON
yum -y install perl-Digest-SHA
yum -y install perl-Digest
yum -y install perl-DBD-Pg
Downloaded pgbackrest
I guess it depends on this
https://www.postgresql.org/message-id/15466-0b90383ff69c6e4b%40postgresql.org
Thanks
Il giorno ven 1 mar 2019 alle ore 09:17 Nicola Contu
ha scritto:
> Hello,
> we are trying to move our postgres 10.5 instance to 11.2
>
> We are trying to restore a DB in a pre-product
On 3/1/19 2:17 AM, Nicola Contu wrote:
Hello,
we are trying to move our postgres 10.5 instance to 11.2
We are trying to restore a DB in a pre-production env but we get an error
on the pg_restore command
[root@STAGING]# /usr/local/pgsql11.2/bin/pg_restore -v -U postgres -L
/data/cofinder_res
Hello,
we are trying to move our postgres 10.5 instance to 11.2
We are trying to restore a DB in a pre-production env but we get an error
on the pg_restore command
[root@STAGING]# /usr/local/pgsql11.2/bin/pg_restore -v -U postgres -L
/data/cofinder_restore.lst -d cofinder -j 16
/home/ncontu/da
23 matches
Mail list logo
