Le dimanche 26 janvier 2014 à 10:27 -0700, Scott Ribe a écrit :
> Is there an article anywhere which documents everything the current state of
> the art for the fastest dump/restore? What dump/restore format & options?
> What things to tweak in the config? I've picked up a few bits here and there
2014-01-27 Vincent Veyron :
> Le dimanche 26 janvier 2014 à 10:27 -0700, Scott Ribe a écrit :
>> Is there an article anywhere which documents everything the current state of
>> the art for the fastest dump/restore? What dump/restore format & options?
>> What things to tweak in the config? I've pi
Dear All
I am new to this list and postgres
I have configured postgresql on my laptop. I want to make a simple web
application that saves the data in database in table demog, which has three
fields
Name, Age and Sex
I have created the table and fields.
I have Netbeans IDE also installed.
and
On 27/01/2014 12:11, Manoj Soni wrote:
> Dear All
> I am new to this list and postgres
>
>
> I have configured postgresql on my laptop. I want to make a simple web
> application that saves the data in database in table demog, which has
> three fields
>
> Name, Age and Sex
>
> I have created the
Raymond O'Donnell wrote:
> On 27/01/2014 12:11, Manoj Soni wrote:
> >
> > Name, Age and Sex
> > Which tutorial, may help me in this regard.
>
> I did a Google search on "tomcat netbeans postgresql tutorial" and
> turned up some likely-looking links should work for you too. :-)
Right, and a
Em 27/01/2014 13:19, Raymond O'Donnell escreveu:
On 27/01/2014 15:16, Edson Richter wrote:
Em 27/01/2014 10:42, Andreas Kretschmer escreveu:
Raymond O'Donnell wrote:
On 27/01/2014 12:11, Manoj Soni wrote:
Name, Age and Sex
Which tutorial, may help me in this regard.
I did a Google search o
On 01/27/2014 07:19 AM, Raymond O'Donnell wrote:
On 27/01/2014 15:16, Edson Richter wrote:
Em 27/01/2014 10:42, Andreas Kretschmer escreveu:
Raymond O'Donnell wrote:
On 27/01/2014 12:11, Manoj Soni wrote:
Name, Age and Sex
Which tutorial, may help me in this regard.
I did a Google search o
On 27/01/2014 15:16, Edson Richter wrote:
> Em 27/01/2014 10:42, Andreas Kretschmer escreveu:
>> Raymond O'Donnell wrote:
>>
>>> On 27/01/2014 12:11, Manoj Soni wrote:
Name, Age and Sex
Which tutorial, may help me in this regard.
>>> I did a Google search on "tomcat netbeans postgresql t
Em 27/01/2014 10:42, Andreas Kretschmer escreveu:
Raymond O'Donnell wrote:
On 27/01/2014 12:11, Manoj Soni wrote:
Name, Age and Sex
Which tutorial, may help me in this regard.
I did a Google search on "tomcat netbeans postgresql tutorial" and
turned up some likely-looking links should wo
Hello,
We have recently shifted to postgresql version 9.2.4 from 9.1.3. After the
migration, we observed that some of our delete queries on single table
[which have triggers, which in turn call other functions] have started
consuming large amounts of memory.
In 9.1.3, this usage was upto 25MB wit
Bhushan Pathak writes:
> In 9.1.3, this usage was upto 25MB with the same load on the same server.
> With 9.2.4 it has jumped upto ~580 MB. We are monitoring the RES column
> from top output to get the memory usage.
On most versions of "top", examining RES alone gives a completely
misleading impr
On 01/27/2014 07:19 AM, Raymond O'Donnell wrote:
On 27/01/2014 15:16, Edson Richter wrote:
Em 27/01/2014 10:42, Andreas Kretschmer escreveu:
Raymond O'Donnell wrote:
On 27/01/2014 12:11, Manoj Soni wrote:
Name, Age and Sex
Which tutorial, may help me in this regard.
I did a Google search o
On 01/27/2014 09:30 AM, Steve Crawford wrote:
On 01/27/2014 07:19 AM, Raymond O'Donnell wrote:
On 27/01/2014 15:16, Edson Richter wrote:
Em 27/01/2014 10:42, Andreas Kretschmer escreveu:
Raymond O'Donnell wrote:
On 27/01/2014 12:11, Manoj Soni wrote:
Name, Age and Sex
Which tutorial, may h
On Sat, Jan 25, 2014 at 10:44 PM, john.tiger wrote:
> scenario: download key data in json format to mobile - then use offline (ie
> in areas where no wifi available) - then when back in wifi range, sync with
> db server
>
> this is what pouch, couch offers but would like to do with postgresql if
I tried:
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO testuser;
and I get:
ERROR: syntax error at or near "ALL"
LINE 1: GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO te...
also the same thing for tables, with the same results.
Am I misinterpreting the syntax for this?
On 01/27/2014 01:45 PM, Susan Cassidy wrote:
I tried:
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO testuser;
and I get:
ERROR: syntax error at or near "ALL"
LINE 1: GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO te...
also the same thing for tables, with the same resul
Alban Hertroys wrote:
> That raises an interesting question: How far back will support
> for older versions in pg_dump go?
http://www.postgresql.org/docs/current/interactive/app-pgdump.html#PG-DUMP-NOTES
says:
| pg_dump can also dump from PostgreSQL servers older than its own
| version. (Curre
Kevin Grittner writes:
> Alban Hertroys wrote:
>> That raises an interesting question: How far back will support
>> for older versions in pg_dump go?
> http://www.postgresql.org/docs/current/interactive/app-pgdump.html#PG-DUMP-NOTES
> says:
> | pg_dump can also dump from PostgreSQL servers olde
Adrian Klaver writes:
> On 01/27/2014 01:45 PM, Susan Cassidy wrote:
>> I tried:
>> GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO testuser;
>> and I get:
>> ERROR: syntax error at or near "ALL"
>> Am I misinterpreting the syntax for this?
> Depends on what version of Postgres you are
This is 9.2
On Mon, Jan 27, 2014 at 4:16 PM, Tom Lane wrote:
> Adrian Klaver writes:
> > On 01/27/2014 01:45 PM, Susan Cassidy wrote:
> >> I tried:
> >> GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO testuser;
> >> and I get:
> >> ERROR: syntax error at or near "ALL"
> >> Am I mis
Susan Cassidy writes:
> This is 9.2
I'd bet a very good dinner that it isn't --- maybe your psql is,
but your server has to be pre-9.0. Try "select version();" to
see the actual version of the server you're connected to.
regards, tom lane
--
Sent via pgsql-general mai
Hello guys!
I have found a example in Oracle and I am trying to do it in Postgre.
Lets say that we have 2 tables.
Create Table "table1" Of "type1"
Create Table "table2" Of "type2"
I want to refer the first table in the second. I want to reference the whole
table not only one field, so somethi
On 01/24/2014 04:58 PM, Jim Mlodgenski wrote:
On Fri, Jan 24, 2014 at 4:20 AM, Emmanuel Medernach mailto:meder...@clermont.in2p3.fr>> wrote:
Hello,
I'm currently testing postgres_fdw feature on PostgreSQL 9.3.2 and I have
some questions:
- What are the limits to the number
Complex in its implementation - maybe. Complex in its configuration and
ideology - nope.
> Are you running your cluster in synchronous mode across geographically diverse
data centers?
Config option #1 ("allow replicas to re-bind to the second synchronous
master if the first one fails, and allow th
On Mon, Jan 27, 2014 at 2:02 AM, antono124 wrote:
> Lets say that we have 2 tables.
> Create Table "table1" Of "type1"
> Create Table "table2" Of "type2"
>
> I want to refer the first table in the second. I want to reference the whole
> table not only one field, so something like that:
>
> CREATE
Hi PG Community,
Does anyone know any code coverage tool and static analysis tool for PL/SQL
or PL/pgSQL code?
Thanks~
Ning
On 1/26/2014 9:02 AM, antono124 wrote:
I want to refer the first table in the second. I want to reference the whole
table not only one field, so something like that:
does this table1 have a primary key? if so, referencing the PK allows
you to fetch the whole row via a join. if this table do
On 1/26/2014 12:35 AM, Dmitry Koterov wrote:
PostgreSQL supports synchronous multi-master
no, PostgreSQL does not support multi-master, not without some sort of
third party replication system, all of which have serious compromises.
--
john r pierce 37N
28 matches
Mail list logo
