This is hard to tell, but You can get some estimation.
1. You can have WAL rate estimation from pg_xlog/ dir, i.e. How many WAL
generated per minutes
2. How long this pg_basebackup will last. Lets say for 3 hours.
Then You can multiple values in #1 and #2 to get rough estimation.
Hope this would h
On 10/22/2014 06:45 PM, Postgres India wrote:
> Hi,
> I am trying to connect DB2 from postgres using dblink, is there any
> configuration required at DB2 and postgres server.
You'll need dbi-link (which uses Perl's DBI drivers) or a foreign data
wrapper.
dblink is for connections between Postgre
Hi,
On Thu, 2014-10-30 at 00:47 -0700, Postgres India wrote:
> configure: error: odbc_config not found (required for unixODBC build)
I think you need to install unixODBC-devel rpm via yast.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
Postgr
Fabio Ugo Venchiarutti writes:
>>> Conversion of the pattern to an index qualification requires that the
>>> pattern be a plan-time constant. STABLE functions, by definition,
>>> are not that.
> I guess it is correct to assume that the same applies to regular
> expressions stored in pl/pgsql va
> Conversion of the pattern to an index qualification requires that the
> pattern be a plan-time constant. STABLE functions, by definition,
> are not that.
Thank you very much
I guess it is correct to assume that the same applies to regular
expressions stored in pl/pgsql variables/arguments t
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
> On 10/30/2014 12:02 PM, Torsten Förtsch wrote:
> >I don't know if this is the right mailing list for my question but I
> >have already emailed pla...@postgresql.org without any response.
That's the correct place to ask. -general is not.
> >So,
On 10/30/2014 12:02 PM, Torsten Förtsch wrote:
Hi,
I don't know if this is the right mailing list for my question but I
have already emailed pla...@postgresql.org without any response.
What is the correct way to get a blog listed on planet postgres?
The documented way does not work. I register
Hi,
I don't know if this is the right mailing list for my question but I
have already emailed pla...@postgresql.org without any response.
What is the correct way to get a blog listed on planet postgres?
The documented way does not work. I registered my blog on Monday. It
still is in "Not approve
I need to get an idea of how much WAL space will be required during a long
(many hours) pg_basebackup over a relatively slow network connection. This
is for a server that's not yet running PITR / streaming.
Any thoughts?
* *
The psql console still operates mainly at the SQL level of input. You need
to use your OS's shell to run pg_dump.
Both psql and pg_dump are the same kind of application and are run in a
similar fashion.
David J.
On Thu, Oct 30, 2014 at 11:13 AM, CrabbeS [via PostgreSQL] <
ml-node+s1045698n5825
Thanks Adrian Klaver, Its really helped me to solve my problem, ya i have
example_list = jsonfield.JSONField() in models. Apologies i did not mention
that. but anyways thank again.
On Thu, Oct 30, 2014 at 8:09 PM, Adrian Klaver
wrote:
> On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wrote:
>
>> @Adri
CrabbeS wrote
> I am trying to copy a table form one database to another by using this
> command in the SQL-query builder:
> pg_dump TA2000 -t from Forest -c -s | psql -h localhost postgis;
pg_dump is a standalone application (i.e., something you run in a
shell/command-line) and not an SQL command
On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wrote:
@Adrian Klaver, Thanks for this idea but still m really confused with
how to update the json filed in the DB. is there any way to update the
json field in the DB through view.?
Realized I should have shown at least one concrete example so, assum
On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wrote:
@Adrian Klaver, Thanks for this idea but still m really confused with
how to update the json filed in the DB. is there any way to update the
json field in the DB through view.?
Sure, how you would normally update a value. Assuming id is unique:
Fabio Ugo Venchiarutti writes:
> As you can see, CONCAT()'s output isn't deemed suitable for an index
> scan. The same happens for all type-compatible STABLE functions i tried.
Conversion of the pattern to an index qualification requires that the
pattern be a plan-time constant. STABLE function
Hi !
Can anyone share any experiences with running PostgreSQL on a
tablet ? (Surface Pro 3, ASUS Transformer)
(or point to things I should read, searching the web didn't
turn up anything that seemed relevant to *tablets*)
Thanks,
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E16
2014-10-30 8:47 GMT+01:00 Postgres India :
> Hi ,
>
> While i try to install psqlDDBC, i get this error , i have SUSE Linux
> Enterprise Server 11 , trying to find a solution still have no idea.
>
> ./configure
> checking for a BSD-compatible install... /usr/bin/install -c
> checking whether build
Hi ,
While i try to install psqlDDBC, i get this error , i have SUSE Linux
Enterprise Server 11 , trying to find a solution still have no idea.
./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkd
18 matches
Mail list logo
