Le 12 avr. 2015 16:50, "Ilya Ashchepkov" a écrit :
>
> Hello.
>
> I'm setting up hot standby slave.
> It recovers from wal archive files, but I can't connect to it:
> $ psql
> psql: FATAL: the database system is starting up
>
> On master:
> # select name,setting from pg_settings where name like '
2015-04-15 10:46 GMT+02:00 Andreas Joseph Krogh :
> På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N <
> nag1...@gmail.com>:
>
>
>
>> I'm planning to vacuum FULL a pg_largeobject relation (after vacuumlo'ing
>> it). The relation is 300GB large so I'm concerned the operation will write
2015-05-03 16:10 GMT+02:00 Yves Dorfsman :
>
> I just want to confirm that currently there is no scheduler that isn't
> dependent on a crontab (like PgAgent), that could be run entirely from
> within
> PostgreSQL only.
>
> Anybody knows of one?
>
>
There's none.
--
Guillaume.
http://blog.guil
2015-05-03 16:55 GMT+02:00 Pavel Stehule :
>
>
> 2015-05-03 16:40 GMT+02:00 Guillaume Lelarge :
>
>> 2015-05-03 16:10 GMT+02:00 Yves Dorfsman :
>>
>>>
>>> I just want to confirm that currently there is no scheduler that isn't
>>> dependent
2015-05-22 18:36 GMT+02:00 Piotr Gasidło :
> 2015-05-22 6:55 GMT+02:00 Fujii Masao :
> >
> > This problem happens when WAL record is stored in separate two WAL files
> and
> > there is no valid latter WAL file in the standby. In your case, the
> former file
> > is 00044C4D0090 and the
2015-05-25 15:15 GMT+02:00 Piotr Gasidło :
> 2015-05-25 11:30 GMT+02:00 Guillaume Lelarge :
>
> >> I currently have wal_keep_segments set to 0.
> >> Setting this to higher value will help? As I understand: master won't
> >> delete segment and could stre
Hi,
2015-06-01 19:57 GMT+02:00 Ivann Ruiz :
> I just setup my databases and got this LOG:
>
> LOG: database system was shut down in recovery at 2015-06-01 13:31:21 EDT
> LOG: entering standby mode
> LOG: redo starts at 0/67000278
> LOG: consistent recovery state reached at 0/67000350
> LOG:
When I ran -> psql -c "SELECT pg_current_xlog_location()"
> -h192.168.0.10 (primary host)
>
Well, you can't execute it on a slave. You can use
pg_last_xlog_receive_location() and pg_last_xlog_replay_location() on a
slave.
>
> On Mon, Jun 1, 2015 at 2:
Le 8 juin 2015 2:48 PM, "otheus uibk" a écrit :
>
> The manual and in this mailing list, the claim is made that consistent,
file-level backups may be made by bracketing the file-copy operation with
the postgresql pg_start_backup and pg_stop_backup operations. Many people
including myself have fou
Le 16 juin 2015 10:57 AM, "Xavier 12" a écrit :
>
> Hi everyone,
>
> Questions about pg_xlogs again...
> I have two Postgresql 9.1 servers in a master/slave stream replication
> (hot_standby).
>
> Psql01 (master) is backuped with Barman and pg_xlogs is correctly
> purged (archive_command is used).
say on its log files?
2015-06-16 12:41 GMT+02:00 Guillaume Lelarge :
> > Le 16 juin 2015 10:57 AM, "Xavier 12" a écrit :
> >>
> >> Hi everyone,
> >>
> >> Questions about pg_xlogs again...
> >> I have two Postgresql 9.1 servers in a mas
Le 3 juil. 2015 12:03 PM, "howardn...@selestial.com" <
howardn...@selestial.com> a écrit :
>
> Hi everyone,
>
> I am reaching the point with my database backups where the backups are
taking too long, and starting to interfere with running of the system
during the day. So I am looking for a bit of s
Le 3 juil. 2015 12:31 PM, "howardn...@selestial.com" <
howardn...@selestial.com> a écrit :
>
>
>
> On 03/07/2015 11:15, Guillaume Lelarge wrote:
>>
>>
>> pg_dumpall is not more efficient than pg_dump. As far as I can tell,
you're looking for PIT
Hi,
Le 16 juil. 2015 2:23 AM, "Ken Tanzer" a écrit :
>
> Hi. I'm looking into adding daterange exclusions to some of my tables.
Following the documentation, I can do this no problem to prevent any
records from overlapping:
>
> CREATE TEMP TABLE foo (
> client_id integer,
> start_date date NO
2015-07-23 9:06 GMT+02:00 Tim Smith :
> So tell me guys, instead of bashing away at the fact I only quoted
> half a sentence or whatever, how about you answer the following :
>
> What exactly is was the design decision that lead to TRUNCATE being
> supported by triggers but not by rules ?
>
>
Some
Hi,
Le 10 août 2015 7:43 AM, "Sachin Srivastava" a
écrit :
>
> Dear Team,
>
> If I have taken any backup successfully through pg_dump? How can I
restore this pg_dump(Sql file) without use of pg_restore.
>
> There is any command line option or through psql, kindly inform to me.
>
If it's an SQL f
Please keep the list in your answers.
Le 10 août 2015 7:51 AM, "Sachin Srivastava" a
écrit :
>
> Dear Guillaume,
>
> What is the syntax of this (psql), kindy confirm.
>
That can be: psql -f the_file the_database
> Regards,
> Sachin
>
> On Mon, Aug 10
Hi,
Le 13 août 2015 9:51 PM, "Jeff Janes" a écrit :
>
> I am looking for an extension or a technique that will allow me to
intercept a query by the exact query text, and replace that query with a
different one.
>
> The context is running a third-party app which issues queries I have no
control ov
Le 26 août 2015 2:06 AM, "Edson Richter" a écrit :
>
> Any chance to get those amazing wonderful features backported to 9.4?
>
No. Only bug fixes are backported.
--
Guillaume.
2015-09-09 17:06 GMT+02:00 Pavel Suderevsky :
> Laurenz, Merlin,
>
> Thanks a lot for your explanations.
>
> >Even if postgres does not cache the table, the o/s will probably
> > still cache it assuming it has the memory to do so.
>
> Could you please clarify, do I understand right that there are
Le 18 sept. 2015 5:23 AM, "Adrian Klaver" a
écrit :
>
> On 09/17/2015 05:37 PM, Michael Chau wrote:
>>
>> 1)
>>
>> In Production, I have a DB2 which is replicated partially using
Londiste
>> from DB1.
>>
>>
>> Well I think the above needs more explanation to help understand how the
>> DB2
2015-10-15 20:40 GMT+02:00 anj patnaik :
> It's a Linux machine with 8 CPUs. I don't have the other details.
>
> I get archive member too large for tar format.
>
> Is there a recommended command/options when dealing with very large
> tables, aka 150K rows and half of the rows have data being inser
2015-10-15 23:05 GMT+02:00 Adrian Klaver :
> On 10/15/2015 01:35 PM, anj patnaik wrote:
>
>> Hello all,
>> I will experiment with -Fc (custom). The file is already growing very
>> large.
>>
>> I am running this:
>> ./pg_dump -t RECORDER -Fc postgres | gzip > /tmp/dump
>>
>> Are there any other o
2015-10-28 21:09 GMT+01:00 anj patnaik :
> I was trying to achieve smallest file possible so tried the xz. Right now
> the db size returned from SELECT
> pg_size_pretty(pg_database_size('postgres') is 1.4 GB and the size of the
> dump with xz is 2.2 GB.
>
> Is there a limit to the size of the data
Le 4 nov. 2015 10:23 AM, "M Tarkeshwar Rao"
a écrit :
>
> Hi all,
>
> We have started to convert some oracle sql scripts and converting them to
postgres, but facing some issues to create table.
>
> I have some common doubts in create table script ie.
>
> ALTER TABLE employee
> DROP PRIMARY KEY CAS
2015-11-12 19:43 GMT+01:00 Adrian Klaver :
> On 11/12/2015 10:02 AM, anj patnaik wrote:
>
>> I get this warning when trying to fetch data for a postgres db. Does
>> this indicate a real issue? Thanks
>>
>
> Well it means the statistics for the table are out of touch with reality.
> The database wi
2015-11-12 23:21 GMT+01:00 Doiron, Daniel :
> I’m troubleshooting a schema and found this:
>
> Indexes:
> "pk_patient_diagnoses" PRIMARY KEY, btree (id)
> "index_4341548" UNIQUE, btree (id)
> "idx_patient_diagnoses_deleted" btree (deleted)
> "idx_patient_diagnoses_diagnosis_type_id
2016-06-20 17:03 GMT+02:00 Scott Mead :
>
>
> On Mon, Jun 20, 2016 at 6:13 AM, Andreas Kretschmer <
> andr...@a-kretschmer.de> wrote:
>
>>
>>
>> Am 20.06.2016 um 11:43 schrieb Job:
>>
>>> Hi Andreas,
>>>
>>> I would suggest run only autovacuum, and with time you will see a not
more growing ta
Le 6 juil. 2016 4:48 AM, "Michael Paquier" a
écrit :
>
> On Wed, Jul 6, 2016 at 11:37 AM, 苏士涛 wrote:
> > I am new to PostgreSQL, and i have a question about streaming
> > replication. If i enable some extension on master with or without
> > native code(in c), do I need to enable this extension on
2016-08-12 11:00 GMT+02:00 Alexander Farber :
> Francisco, thanks, but -
>
> On Fri, Aug 12, 2016 at 10:47 AM, Francisco Olarte > wrote:
>
>>
>> https://www.postgresql.org/docs/9.5/static/plpgsql-statement
>> s.html#PLPGSQL-STATEMENTS-SQL-ONEROW
>>
>>
> but the custom function I am trying to call
2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh :
> På tirsdag 08. mars 2016 kl. 21:03:01, skrev David G. Johnston <
> david.g.johns...@gmail.com>:
>
> On Tue, Mar 8, 2016 at 9:45 AM, Andreas Joseph Krogh
> wrote:
>
>> På tirsdag 08. mars 2016 kl. 17:38:04, skrev Joshua D. Drake <
>> j...@command
2016-10-23 20:37 GMT+02:00 Andreas Joseph Krogh :
> På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh <
> andr...@visena.com>:
>
> På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge <
> guilla...@lelarge.info>:
>
> 2016-03-08 21:
2016-10-23 20:44 GMT+02:00 Guillaume Lelarge :
> 2016-10-23 20:37 GMT+02:00 Andreas Joseph Krogh :
>
>> På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh <
>> andr...@visena.com>:
>>
>> På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume
u're right. v3 (attached) fixes this.
> Apart from this concern patch looks good to me. Thanks
>
>
Thanks.
> Regards,
> Amul
>
> The new status of this patch is: Waiting on Author
>
> On Mon, Oct 24, 2016 at 12:19 AM, Guillaume Lelarge
> wrote:
> > 2016-
Hi Amul,
2016-11-04 7:52 GMT+01:00 amul sul :
> Hi Guillaume,
>
> I found following issues with this patch, sorry missed in previous post:
>
>
You don't have to be sorry for me doing shitty things :)
> #1 :
> 43 @@ -392,6 +393,10 @@ main(int argc, char **argv)
> 44 dopt.output
2016-11-04 9:35 GMT+01:00 Guillaume Lelarge :
> Hi Amul,
>
> 2016-11-04 7:52 GMT+01:00 amul sul :
>
>> Hi Guillaume,
>>
>> I found following issues with this patch, sorry missed in previous post:
>>
>>
> You don't have to be sorry for me doing shi
2016-11-07 7:06 GMT+01:00 amul sul :
> On Mon, Nov 7, 2016 at 2:03 AM, Guillaume Lelarge
> wrote:
> >>
> >> Agreed. I was afraid of that, but for some reason, didn't find that.
> I'll
> >> fix this.
> >
> >
> > Fixed in v4.
>
2016-11-08 6:01 GMT+01:00 amul sul :
> On Tue, Nov 8, 2016 at 5:36 AM, Andreas Joseph Krogh
> wrote:
> >
> >
> > I don't see what you mean. It forces dump of Blobs if we didn't use -B
> and
> > if we include everything in the dump, which seems good to me. What did
> you
> > try that didn't work a
Le 18 nov. 2016 2:03 PM, "otheus uibk" a écrit :
>
> A glaring weakness in Postgresql for production systems is that the
administrator has no way of controlling what types of logs go where. There
are at least two types of logs: errors and statement logs. (I could also
add: connection, syntax error
2016-11-21 14:44 GMT+01:00 Benedikt Grundmann :
> Hello all,
>
> I have a quick question. I feel like somewhere in section 23.1.6 there
> should be the answer but I couldn't find it yet. Namely how can I query
> the database for total number of tuples inserted, updated, or deleted since
> the la
2016-12-21 20:29 GMT+01:00 Daniel Westermann <
daniel.westerm...@dbi-services.com>:
> >> postgres@pgbox:/home/postgres/ [PG961] pg_restore -h localhost -p 5439
> -F d -C -j 2 /var/tmp/exp/
> >>
> >> This runs fine but where does it connect to? Nothing is listening on
> port 5439.
>
> >Given the la
2016-02-29 14:31 GMT+01:00 Stephen Frost :
> * David G. Johnston (david.g.johns...@gmail.com) wrote:
> > Given the amount of damage a person with write access to a table can get
> > into it seems pointless to not allow them to analyze the table after
> their
> > updates - since best practices woul
2016-02-29 15:20 GMT+01:00 Vik Fearing :
> On 02/29/2016 03:15 PM, Guillaume Lelarge wrote:
> > 2016-02-29 14:31 GMT+01:00 Stephen Frost > <mailto:sfr...@snowman.net>>:
> >
> > Realistically, ANALYZE is a background/maintenance task that
> autovacuu
2016-04-19 5:41 GMT+02:00 Jinhua Luo :
> > Does that mean a VOLATILE function runs in a different transaction?
>
> No, all statements triggered by the outer statement is within the same
> transaction. If the trigger fails (without trapping the error), all
> affects including changes by outer state
2016-04-25 15:06 GMT+02:00 Victor Yegorov :
> Greetings.
>
> I cannot get understanding about what different types of blocks means here:
> http://www.postgresql.org/docs/current/interactive/pgstatstatements.html
>
>
> I assume, that `shared` are blocks from the `shared_buffers`
> and `temp` are bl
Le 3 mai 2016 7:01 PM, "Evgeny Morozov"
a écrit :
>
> That's an interesting idea! The client users would use is probably
pgAdmin. I don't know whether pgAdmin parses the query, though. If it does
then it should be relatively easy to add this. If not, I'd imagine it's not
going to happen.
>
The pg
Hi,
Le 25 mai 2016 4:50 PM, "Arnaud Inovia Team"
a écrit :
>
> I have some question regarding some timezone behaviour.
>
> Documentation is saying:
>
> > When a timestamp with time zone value is output, it is always converted
from UTC to the current timezone zone, and displayed as local time in t
Kenneth Downs a écrit :
> Nikolay Samokhvalov wrote:
>> On 22 May 2007 17:47:46 -0700, EMS Database Management Solutions
>> (SQLManager.net) <[EMAIL PROTECTED]> wrote:
>>> We, here at EMS Database Management Solutions, are pleased to announce
>>> SQL Manager 2007 for PostgreSQL - the new major vers
Le 29/10/2010 13:52, Rob Richardson a écrit :
> A customer was reviewing the database that supports the application we
> have provided. One of the tables is very simple, but has over 16
> million records. Here is the table's definition:
>
> CREATE TABLE feedback
> (
> charge integer,
> elap
Le 29/10/2010 14:46, Guillaume Lelarge a écrit :
> Le 29/10/2010 13:52, Rob Richardson a écrit :
>> A customer was reviewing the database that supports the application we
>> have provided. One of the tables is very simple, but has over 16
>> million records. Here is t
Le 01/11/2010 06:41, Eduardas Tcpa a écrit :
>>
>> Hello I'm getting into strange problem with pgAdmin 3.
>> As we all know, PostgreSQL enforces index creation on primary key's.
>> The problem with this is the fact, that when i create a table in pgAdmin's
>> sql editor, in result window i'm getting
Le 08/11/2010 16:18, Alexander Farber a écrit :
> Thank you,
>
> alter table pref_users add constraint pref_users_medals_check check
> (medals >= 0);
>
> has worked!
>
> I do not use pgAdmin, because I see in the logs of my 2 web server,
> that attackers look for it all the time. But I'll instal
Le 11/11/2010 13:01, Vangelis Katsikaros a écrit :
> Hello
>
> I have postrges 8.3.12 and I have the following issue:
>
> I have a table
> create table test(
> table_id integer,
> datetime timestamp,
> MMSI integer,
> lat real,
> lng real,
> );
>
> and I bulk insert data
Le 11/11/2010 17:46, Vangelis Katsikaros a écrit :
> On 11/11/2010 03:05 PM, Guillaume Lelarge wrote:
>>
>> You should better look at pgloader which will use COPY to put your data
>> in your table and found the lines in error. Of course, it takes time to
>> detect lines
Le 11/11/2010 18:58, Rob Sargent a écrit :
>
>
> On 11/11/2010 09:50 AM, Aram Fingal wrote:
>> A while back, I thought I remembered seeing a Mac OS X client for PostgreSQL
>> which had a feature where it would display a graphic schema of whatever
>> database you connect to but I can't seem to f
Le 13/11/2010 17:43, Raymond O'Donnell a écrit :
> On 13/11/2010 03:43, Elliot Chance wrote:
>> Hi everyone,
>>
>> This is my first post on the mailing list :)
>>
>> As of today I have started the first dedicated postgres forum at:
>> http://forums.postgresql.com.au
>
> Hi there,
>
> Without in a
Le 25/11/2010 11:02, Gera Mel Handumon a écrit :
> Hello,
>
> What version of pgadmin3 to be used for postgresql 9 running on CentOS
> 5? I encountered some errors when i used the pgadmin3 1.8.4. I've
> search for newer version of pgadmin3 for Linux but no luck at all.
>
You need the 1.12 releas
Le 27/11/2010 13:59, Emanuel Calvo Franco a écrit :
> I'm having this 'issue':
>
> coches=# select array_agg(patente order by fecha desc) from
> dia4.infraccion limit 6;
>
>array_agg
>
> -
Le 27/11/2010 09:52, Zhipan Wang a écrit :
> Hi,
>
> I want to access part of a table on the disk sequentially, i,e., when I get
> to a tuple in the table, I need to read several pages of data in the table
> starting from this tuple.
You shouldn't rely on the order on disk. It will change as so
Please send your answer (also) to the list.
Le 28/11/2010 10:23, zhipan Wang a écrit :
> [...]
> Thanks a lot for your detailed reply. I am trying to implement the idea
> proposed
> in the paper Database Cracking. The basic idea is like this:
>
> When a query with a range predicate like "a col
Le 03/12/2010 07:34, Konstantin Izmailov a écrit :
> Dmitriy,
> It worked like a charm! Bol'shoe spasibo!
>
> I'm curious what are the Postgres versions that support MOVE ALL. The
> documentation does not even mention "ALL" option.
>
Actually, it does:
http://www.postgresql.org/docs/9.0/inter
Le 03/12/2010 21:22, manfred.braun a écrit :
> [...]
> Yes, thanks, I am just trying to lern the difference.
> I am comin from Sql Server, but I am not a experienced
> db developer. But in Sql Server, you may hack your tests
> just in a direct statement and if it runs, wrap/put
> it in the function
Le 05/12/2010 14:43, Stefan Keller a écrit :
> I've recently installed newest Postgres 9.1 Alpha 1
> (postgresql-9.1alpha1-windows-binaries.zip from
> http://www.enterprisedb.com/products/pgbindownload.do ) and got a
> similar question around this:
>
> There's pgAdmin3 v.1.13 included but it still
Le 08/12/2010 22:41, Ivan Sergio Borgonovo a écrit :
> On Wed, 8 Dec 2010 13:40:29 -0500 (EST)
> "James B. Byrne" wrote:
>
>> I am testing a Rails deployment and wish to copy a database
>> assigning it an new owner. I have tried this:
>>
>> createdb --owner=hll_theheart_db_devl
>> --template=hll
Le 10/12/2010 16:01, Gevik Babakhani a écrit :
> I was wondering if there are any schema manipulation statements which
> are not allowed from within a PL/PGSQL function. (Except from
> create/drop a database)
>
create/drop tablespace
They are the only exception AFAICT.
--
Guillaume
http://ww
Le 15/12/2010 17:26, Adrian Klaver a écrit :
> On 12/15/2010 07:34 AM, Andrus Moor wrote:
>>> No, this is just pilot error. Any version of pg_dump will produce
>>> output that is meant to be loaded into the matching server version
>>> (or a later version). If you are intending to load back into 8.4
Le 22/12/2010 21:34, Mark Watson a écrit :
> Hello all,
> (Postgres 8.4.6 Windows)
> I am stumped as to why I cannot import this using copy from within pgadmin
> (the following table is created in an existing database with an encoding of
> WIN1252 and the Postgres server_encoding is UTF8) :
> CREAT
Le 23/12/2010 14:36, Mark Watson a écrit :
> Le 22/12/2010 21:34, Mark Watson a écrit :
>> Hello all,
>> (Postgres 8.4.6 Windows)
>> I am stumped as to why I cannot import this using copy from within pgadmin
>> (the following table is created in an existing database with an encoding
> of
>> WIN1252
Le 27/12/2010 18:57, Michael Satterwhite a écrit :
> I'm new to PostgreSQL, but have worked with other databases. I'm trying to
> write a trigger to default a timestamp column to a fixed interval before
> another. The test setup is as follows:
>
> create table test
> ( date1 timestamp,
>
Le 27/12/2010 18:27, Gauthier, Dave a écrit :
> Hi:
>
> I'm working with 2 different PG installs on 2 different linux servers, one
> running v9.0.1 and the other v8.3.4. The older install is "frozen" for the
> project (which is nearing completion) for environment stability reasons.
> This is
Le 27/12/2010 20:38, John R Pierce a écrit :
> On 12/27/10 11:00 AM, Guillaume Lelarge wrote:
>> Le 27/12/2010 18:27, Gauthier, Dave a écrit :
>>> Hi:
>>>
>>> I'm working with 2 different PG installs on 2 different linux
>>> servers, one runni
Le 27/12/2010 22:02, Richard Broersma a écrit :
> On Mon, Dec 27, 2010 at 12:50 PM, InterRob wrote:
>> pgsql Command "\d test" produces the following:
>>Table "public.test"
>>Column | Type | Modifiers
>> +-+---
>> object_id | integer |
>> subject_id
Le 27/12/2010 22:16, Michael Satterwhite a écrit :
> On Monday, December 27, 2010 12:58:40 pm Guillaume Lelarge wrote:
>> Le 27/12/2010 18:57, Michael Satterwhite a écrit :
>>> I'm new to PostgreSQL, but have worked with other databases. I'm trying
>>> to w
Le 29/12/2010 05:28, Bricklen a écrit :
> On 2010-12-28, at 5:22 PM, Tom Lane wrote:
>
>> bricklen writes:
>>> In the docs at
>>> http://www.postgresql.org/docs/9.0/static/sql-createindex.html,
>>> I see that you can build indexes that include ordering.
>>> Eg. create index t_col_idx on t (col
Le 26/01/2011 00:28, margaretgil...@chromalloy.com a écrit :
> Using these instructions
>
> http://wiki.flexive.org/confluence/display/FX/Postgres+9.x+installation+in+Ubuntu?focusedCommentId=4915206#comment-4915206
>
>
>
> I am trying to install current pgadmin3 1.12 on an ubuntu lucid client.
Le 26/01/2011 22:29, Lawrence Cohan a écrit :
> Trying to get some DDL auditing in a development environment by adding
> triggers to pg_proc, pg_class,pg_type,pg_trigger and getting the following
> error:
>
> ERROR: permission denied: "pg_proc" is a system catalog
> SQL state: 42501
>
> Is ther
Le 26/01/2011 23:13, Tom Lane a écrit :
> Guillaume Lelarge writes:
>> Le 26/01/2011 22:29, Lawrence Cohan a écrit :
>>> All I need is to at least be able and save a userid(current_user),
>>> timestamp, action, and the name of the object and this could be done easily
Le 09/02/2011 20:06, Gauthier, Dave a écrit :
> Hi:
>
> Will V9.0.1 streaming replication replicate the effects of "alter database
> foo rename to fee" ?
Yes.
> Will it replicate "analyze" (I do this after a big DB load to give the query
> optimizer good stats to work with)?
AFAIK, yes.
> If
Le 15/02/2011 15:49, Luca Ferrari a écrit :
> Hello,
> I've got a doubt about partial indexes and the path chosen by the optimizer.
> Consider this simple scenario:
>
> CREATE TABLE p( pk serial NOT NULL , val2 text, val1 text, b boolean, PRIMARY
> KEY (pk) );
> INSERT INTO p(pk, val1, val2, b) V
Le 23/02/2011 09:58, Interrogativus a écrit :
> Hi there,
>
> I am currently running Version 1.12.2 (Dec 14 2010, rev: REL-1_12_2) /
> PostgreSQL 9.02 on Windows 7 Ultimate (64-bit)
>
> The problem is the exactly the same as described in this thread
> http://postgresql.1045698.n5.nabble.com/Error
Le 23/02/2011 09:10, salah jubeh a écrit :
> [...]
> This is a simple way to check if there is no activity on the table,
>
> SELECT relname,seq_tup_read,idx_tup_fetch FROM pg_stat_user_tables
> WHERE (idx_tup_fetch + seq_tup_read)= 0;
>
>
> Is there is any way to make similar checks on views
Le 24/02/2011 16:49, gvim a écrit :
> PostgreSQL 9.0.3/Mac OS X 10.6.6
>
> I need to recreate a database at regular intervals and what normally
> works is:
>
> user$: dropdb -U myuser -h localhost mydb;
>
> user $: psql -U myuser -h localhost mydb;
> psql: FATAL: database "mydb" does not exist
>
Le 01/03/2011 07:42, Malm Paul a écrit :
> Hi,
> I'm trying to create a new database by using a template database. But it is
> not possible. The error code is that some one is using the template, but no
> one is using it.
I would bet *you* are connected with pgadmin to the template1 database.
>
Le 16/03/2011 19:37, fjania a écrit :
> I'd like to pass configuration options to the postgres installer on
> ubuntu if possible. Mostly I'm concerned about setting the location of
> the data directory, and where the logs are stored.
>
> I'm familiar with how to configure these after postgres has
Le 29/03/2011 20:44, Thom Brown a écrit :
> Hi all,
>
> I've just set up a test user, revoked all access from them to a
> database, then tried to connect to that database and it let me in.
> When I try it all from scratch, it works correctly.
>
> Here's the set running correctly:
>
> postgres=#
Le 29/03/2011 23:12, Thom Brown a écrit :
> On 29 March 2011 21:59, Guillaume Lelarge wrote:
>> Le 29/03/2011 20:44, Thom Brown a écrit :
>>> Hi all,
>>>
>>> I've just set up a test user, revoked all access from them to a
>>> database, then
Le 30/03/2011 18:02, Paul Gaspar a écrit :
> [...]
> I want to get rid of all those messages like "database system is ready to
> accept connections" in the log file. -s is the appropiate command in pg_ctl,
> I thought, but I still get those messages.
>
> This is the command line to start pg:
>
Le 02/04/2011 11:09, Sven Haag a écrit :
> hello pg fans,
>
> we have an application that communicates via ODBC directly to the postgres
> database.
>
> if i'm trying to add an additional column to a table in pgadmin while clients
> are logged in, pgadmin hangs. only if all cients are logged ou
Le 02/04/2011 16:06, Sven Haag a écrit :
>
> Original-Nachricht
>> Datum: Sat, 2 Apr 2011 14:17:37 +0200
>> Von: Jens Wilke
>> An: pgsql-general@postgresql.org
>> Betreff: Re: [GENERAL] Autovacuum firing up during my manual vacuum on same
>> table
>
>> On Samstag, 2. April 201
Le 07/04/2011 04:05, Yang Zhang a écrit :
> Is it possible to attach or detach parts of a DB (e.g. tablespaces),
> such that I can flexibly move the disks containing the DB tables
> around to different hosts?
>
No, you can't. But you actually don't need to. Users won't be able to
access the objec
2014-07-10 20:56 GMT+02:00 Yves Dorfsman :
>
> Hi,
>
> If I run checkpoint from psql, is it applied to all the databases?
>
> What if I do it though an API? When connecting with psycopg2, I'm forced to
> specify a database name, if I use "dbname=postgres", and execute
> "checkpoint;", is it applie
Hi,
2014-07-22 11:36 GMT+02:00 Rebecca Clarke :
> Hi all,
>
> Presently I'm executing a function that runs many queries within it.
>
> select * from _myfunction();
>
> Is there a way to see what query it is up to within the function?
>
Unfortunately, no. Even with the latest release. pg_stat_act
Hi,
2014-07-27 8:55 GMT+02:00 klo uo :
> Hi,
>
> I believe SQL Editor in pgAdmin wx GUI is Scintilla.
> Scintilla supports calltips (as in SciTE with *.api files).
>
> If above is true, is there a way to make SQL Editor support calltips on
> user defined commands?
>
>
pgAdmin uses scintilla on th
t.
>
> Apologies for posting in wrong list, would be great if Administrator could
> move the message thread to appropriate group.
>
>
That won't happen. This isn't a web forum :)
>
> Thanks,
> Klo
>
>
> On Sun, Jul 27, 2014 at 1:43 PM, Guillaume Lelarg
Le 6 août 2014 18:47, "David G Johnston" a
écrit :
>
> Bill Epstein wrote
> > I've tried a variety of ways based on the on-line docs I've seen, but I
> > always get a syntax error on EXEC when I use only the line EXEC
statement
>
> You likely need to use "EXECUTE" in PostgreSQL
>
>
> >INFO:
2014-08-07 7:24 GMT+02:00 David Johnston :
>
>> > > - What are the differences among PL/SQL, PL/PGSQL and pgScript.
>> >
>> > The first two are languages you write functions in. pgScript is simply
>> an
>> > informal way to group a series of statements together and have them
>> execute
>> > with
Le 16 août 2014 17:44, "lin" a écrit :
>
> Hi all,
> I change the value of "unix_socket_directories" in postgresql.conf ,
then restart the database, but it cannot connect the database used like
this
> "psql -d postgres -p 5432" , it must given the parameter " -h /xx/xx" to
use the Unix doma
Le 29 août 2014 18:13, "Emmanuel Medernach" a
écrit :
>
> Hello,
>
> I use Postgres version 9.3.5 and spot a performance issue
> with postgres_fdw.
>
> I have a table object_003_xyz with 275000 lines and is
> exported to the master node as master_object_003_xyz.
>
> ( The following query
Hi,
Le 9 oct. 2014 01:31, "Andreas Joseph Krogh" a écrit :
>
> Hi all.
>
> I'm having a database, called "apeland", which at first (when created)
was in the default-tablespace (in $PGDATA), then I moved it with the
commands:
>
> # create tablespace apeland location
'/home/andreak/programs/postgre
Hi,
2014-10-15 12:18 GMT+02:00 Léa Massiot :
> Hello and thank you for reading my post.
>
> My question is about starting PostgreSQL clusters at boot time.
>
> The OS is Debian Wheezy.
> I have installed PostgreSQL from the sources (postgresql-9.3.5.tar.gz) at
> http://www.postgresql.org/ftp/sour
1 - 100 of 372 matches
Mail list logo
