Yogesh. Sharma wrote
> Dear David,
>
>> Are you currently using PostgreSQL?
> Currently we are using PostgreSQL 8.1.18 version on RHEL 5.8.
> Now we plan to update this to PostgreSQL 9.0 version with RHEL6.5. As in
> verion 9.0 I found least Compatibilities.
>
> So, please guide me.
>
> Regards
On Friday, August 29, 2014 04:14:35 AM Yogesh. Sharma wrote:
> Dear David,
>
> > Are you currently using PostgreSQL?
>
> Currently we are using PostgreSQL 8.1.18 version on RHEL 5.8.
> Now we plan to update this to PostgreSQL 9.0 version with RHEL6.5. As in
> verion 9.0 I found least Compatibili
age-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G Johnston
Sent: Friday, August 29, 2014 9:22 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Help related to Postgresql for RHEL 6.5
Yogesh. Sharma wrote
> Compatibility issu
Yogesh. Sharma wrote
> Compatibility issues of 9.3 are more.
> So, please guide which version is suitable.
Compatibility as in the multixact issues or does your software not work with
9.3 changes?
What about "any supported version" and the provided link is unclear?
There is no way for us to eva
: [GENERAL] Help related to Postgresql for RHEL 6.5
Hi,
On Thu, 2014-08-28 at 03:22 +, Yogesh. Sharma wrote:
> I want to upgrade RHEL 5.4 to RHEL 6.5.
> So, could you please let me know, which postgresql version is stable
> for RHEL 6.5?
Any supported PostgreSQL version is available i
Hi,
On Thu, 2014-08-28 at 03:22 +, Yogesh. Sharma wrote:
> I want to upgrade RHEL 5.4 to RHEL 6.5.
> So, could you please let me know, which postgresql version is stable
> for RHEL 6.5?
Any supported PostgreSQL version is available in the yum repository:
http://yum.postgresql.org
You ca
Hi Serge,
A million apologies for the delayed acknowledgement of your email. The Yahoo
webmail is doing weird things with conversations (your email was hiding in my
sent box instead of inbox, tagged onto the end of my original email !).
But I digress. I will take a look at your suggestions a
Or...
Do you mean to use windowing functions?
http://www.postgresql.org/docs/9.3/static/tutorial-window.html
Or both of course...
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
2014-08-04 19:43 GMT+02:00 Serge Fonville :
> Hi,
>
> Perhaps a CTE would help?
>
Hi,
Perhaps a CTE would help?
WITH NormCTE AS (
SELECT
delta - avg(delta))/stddev(delta) AS deltaNorm
, (echo - avg(echo))/stddev(echo) AS echoNorm
, (foxtrot - avg(foxtrot))/stddev(foxtrot) AS foxtrotNorm
FROM t_subs
)
SELECT
deltaNorm + echoNorm + foxtrotNorm AS
On 06/05/2014 09:45 AM, Carlos Carcamo wrote:
Just a little, I will read it again, thanks for your help.
In particular:
http://www.postgresql.org/docs/9.3/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-g
Carlos Carcamo wrote
> SELECT myProcedure(product_id, p_description, price, qty, store_id,
> store_description );
>
> waiting for a response from procedure, maybe true or false.
Note that forcing the procedure to return false instead of simply throwing
an error is going to degrade performance. I
Just a little, I will read it again, thanks for your help.
2014-06-05 10:39 GMT-06:00 David G Johnston :
>
> Have you read this chapter of the documentation?
>
> http://www.postgresql.org/docs/9.3/interactive/plpgsql.html
>
>
> Carlos Carcamo wrote
> > What I need is some help with the procedure
Have you read this chapter of the documentation?
http://www.postgresql.org/docs/9.3/interactive/plpgsql.html
Carlos Carcamo wrote
> What I need is some help with the procedure in postgres, I have searched
> in
> google, but I dont know how to do it, the goal is perform the first insert
> and th
What I need is some help with the procedure in postgres, I have searched in
google, but I dont know how to do it, the goal is perform the first insert
and then the second insert if the first one succeed in one procedure
instead of using two separate inserts.
Do you have some code like that?
2014-
Sorry, I meant: "calling a stored procedure you'll write in postgres from
php"
On Thu, Jun 5, 2014 at 5:13 PM, Seref Arikan wrote:
> Hi Carlos,
> When you say procedures, do you mean calling a stored procedure you'll
> write from php? Or executing the individual INSERT from php sequentially?
>
Hi Carlos,
When you say procedures, do you mean calling a stored procedure you'll
write from php? Or executing the individual INSERT from php sequentially?
For the first scenario, you'd need to write a postgresql stored procedure
(I suggest you google: PL/pgSQL tutorial) and call the from php. For
Hi Carlos,
Unless I'm missing something here, your queries are probably being called
from a programming language (java/c# etc) and your database access api
should support transactions. If you perform both operations under the same
db transaction and commit your transaction things should be fine. If
2014-06-05 9:32 GMT-06:00 Carlos Carcamo :
> Hi everyone, I wonder if you could help me with a procedure that I would
> like to perform in postgresql.
>
> I have an insert query like this:
>
> INSERT INTO products (product_id, description, price, qty, ...) values
> ('01', 'some description', 10.15
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Moshe Jacobson
Sent: Friday, March 28, 2014 10:31 AM
To: pgsql-general
Subject: [GENERAL] Help with exclusion constraint
Take the following table:
CREATE TABLE exclusion_example AS
(
pk_col i
On Fri, Mar 28, 2014 at 12:21 PM, Igor Neyman wrote:
> For this:
> "any given value of fk_col that there is a maximum of one row with
> bool_col = true."
>
> why don't you (instead) create partial unique index:
> CREATE UNIQUE INDEX on exclusion_example(fk_col, bool_col) WHERE bool_col
> IS TRUE;
On Fri, Mar 28, 2014 at 12:45 PM, wrote:
> > I want to ensure that for any given value of fk_col that there is a
> maximum
> > of one row with bool_col = true.
>
> This should be what you want:
>
> ALTER TABLE exclusion_example
> ADD CONSTRAINT ex
> EXCLUDE (fk_col WITH =) WHERE (bool_col);
Yes
Moshe Jacobson writes:
> Take the following table:
>
> CREATE TABLE exclusion_example AS
> (
> pk_col integer primary key,
> fk_col integer not null references other_table,
> bool_col boolean not null
> );
>
> I want to ensure that for any given value of fk_col that there is a max
Em 06/02/2014 14:25, Bret Stern escreveu:
You checked pg_hba_conf for host 10.68.73.6?
Is there a matching log entry for the rejection?
Thanks for your effort, Bret!
Problem already solved (I've posted the solution in the list past days).
Problem was a "context.xml" with a wrong database server
You checked pg_hba_conf for host 10.68.73.6?
Is there a matching log entry for the rejection?
On Wed, 2014-02-05 at 09:21 -0200, Edson Richter wrote:
> Dear all, I need your advise. Found a tricky situation.
>
> Without any changes in the configuration files, a **local** connection
> to a local
On 02/06/2014 07:29 AM, Merlin Moncure wrote:
The log is telling you exactly what's happening. "pg_hba.conf" is a
database firewall of sorts that manages whom is allowed to connect to
the database and from where. Fixing this is a matter of adding a rule
to that file. The file is internally we
On Wed, Feb 5, 2014 at 5:21 AM, Edson Richter wrote:
> Dear all, I need your advise. Found a tricky situation.
>
> Without any changes in the configuration files, a **local** connection to a
> local VPN IP address could not be established with the following error:
>
> 2014-02-05 09:12:21.111 - xxx
On Thu, Jan 23, 2014 at 3:46 PM, Bill Moran wrote:
> It was suggested that
> leaving the constraints as NOT VALID might affect the planner, causing
> it to use less optimal plans because it doesn't think it can trust
> the constraint. Is this true?
AFAICT the planner doesn't currently rely on FO
On 23/01/14 14:46, Bill Moran wrote:
>
> Some quickie background: I'm on a project to migrate a fairly large
> database from MySQL to PostgreSQL (~2T). As a result of a number of
> factors, I have to do it in one shot and I have a limited time window
> in which things can be down while I switch i
You could also look into a filtered index that perhaps only covers dates
earlier than a certain point in time where regular performance wouldn't be
hindered. But Gavin is absolutely right otherwise.
On Jan 5, 2014 5:22 PM, "Sergey Konoplev" wrote:
>
> On Sun, Jan 5, 2014 at 2:19 PM, Gavin Flower
On Sun, Jan 5, 2014 at 2:19 PM, Gavin Flower
wrote:
> On 06/01/14 11:08, Sergey Konoplev wrote:
> [...]
>
>> An index might be considered as useless when there were no idx scans for
>> the significantly long period. However it might be non-trivial to define
>> this period. Eg. one have a query bui
On 06/01/14 11:08, Sergey Konoplev wrote:
[...]
An index might be considered as useless when there were no idx scans
for the significantly long period. However it might be non-trivial to
define this period. Eg. one have a query building an annual report
that uses this index and the period here
On Fri, Jan 3, 2014 at 10:53 PM, wrote:
> Index name idx_scan idx_tup_read idx_tup_fetch
> idx1 1000
> 0
> idx2 100 2000
> idx3 100 200
Juan Pablo L wrote:
> Hi, i have a function that receives a parameter which represents days:
>
> FUNCTION aaa_recharge_account(expdays integer)
>
> i want to add those days to the CURRENT_DATE, but i do not know how to do it,
> i have tried several
> ways to replace that in an expresion like:
>
On 12/2/2013 4:11 AM, Tobadao wrote:
I'm using Slony-I and Streaming Replication.
those are two completely different and incompatible replication
methods. a streaming replication MASTER could participate in slony
table replication with a 3rd server, but afaik a streaming SLAVE
can't/should
On Tue, Nov 26, 2013 at 12:24:08PM -0500, David Rysdam wrote:
> I'm not really looking for information on how to speed this query
> up. I'm just trying to interpret the output enough to tell me which step
> is slow:
You might want to read this:
http://www.depesz.com/tag/unexplainable/
Best regard
On 11/26/2013 06:24 PM, David Rysdam wrote:
> I'm not really looking for information on how to speed this query
> up. I'm just trying to interpret the output enough to tell me which step
> is slow:
>
>Seq Scan on mags (cost=0.00..187700750.56 rows=47476 width=4) (actual
> time=3004851.889..
On 2013-11-18 04:37, Ken Tanzer wrote:
If the tables aren't huge, you're not concerned about optimization,
and you just want to get your numbers, I think something like this
would do the trick. I haven't actually tried it 'cause I didn't have
easy access to your tables:
SELECT
a.product_id
In general, when I have to handle Ledger type data (which this problem
is), I tend to hold data in 3 tables
1. Master Ledger ( Product ID, Name, etc)
2. Master Ledger Balances(Product ID, Fiscal_Year, Opening Balance,
Net_Transaction_P1, Net_Transaction_P2, ... etc)
3. Master Ledger Transact
Thanks a lot Ken,
I will try it soon.
But when the table becomes huge (how big 'huge' in postgres ?), how to
optimize such command ?
I have index on all important field like date, productid, supplierid,
customerid and so on
Optimization is really an important thing as i plan to keep all tra
Thanks all for your concern and help.
I have tried David suggestion and it works. As what you all said, there are so
many important feature in PostgreSQL. I really have to spend time to study it.
Last time i use Windev to develop front end application, and HyperfileSQL as
the database server.
If the tables aren't huge, you're not concerned about optimization, and you
just want to get your numbers, I think something like this would do the
trick. I haven't actually tried it 'cause I didn't have easy access to
your tables:
SELECT
a.product_id,
a.product_name,
b.initial_stock_sum,
On 18/11/2013 02:16, Hengky Liwandouw wrote:
> Dear Friends,
>
> Please help for the select command, as i had tried many times and
> always can not display the result as what i want.
>
> I am looking for the solution on google but still can not found the
> right answer to solve the problem.
>
>
Hi
For decades, this type of problem has been the meat and vegetables of
discussions about SQL programming and design.
One writer on this subject has stood out, thanks to his mental clarity
and ability to set out complicated concepts in a readily comprehensible
manner.
His name is Joe Celk
Le mardi 15 octobre 2013 à 08:52 -0700, ginkgo36 a écrit :
> 1. I want to sort string follow anphabet and I used this query:
> select string_agg(x, ';') from (select
> trim(unnest(regexp_split_to_array('ECD FORM; BODY; PREDILUTED; CHROMO-GENIC;
> AUTO;RABBIT; FORMAT',';'))) x order by x) a;
>
> -
Hey short trick :
to avoid to use the schema name multiple time (more readable and more easy
to re use).
You can use the
SET search_path gpstracking_device_tracks, public;
(see manual here :
http://www.postgresql.org/docs/current/static/sql-set.html)
Cheers,
Rémi-C
2013/10/2 Carlos Eduardo Sot
Thanks to all
I have fix that refactoring the function
BEGIN
arr := regexp_split_to_array(_imeis, E'\\s+');
RETURN QUERY
SELECT
gpstracking_device_tracks.imei,
gpstracking_device_tracks.device_id,
gpstracking_device_tracks.date_time_process,
gpstracking_device_tracks.latitude,
gpstracking_de
On Mon, Sep 30, 2013 at 10:03 AM, Carlos Eduardo Sotelo Pinto
wrote:
>
> I need a help on postgresql performance
>
> I have configurate my postgresql files for tunning my server, however it is
> slow and cpu resources are highter than 120%
>
> I have no idea on how to solve this issue, I was tryin
On Sun, Sep 15, 2013 at 7:49 PM, Jeff Janes wrote:
> On Tue, Sep 10, 2013 at 10:37 AM, Chris Curvey > wrote:
>
>>
>>
>>
>>
>> Great thought. Looking through the logs, it appears that all my failures
>> are on a CREATE INDEX. Usually on my biggest table, but often on another
>> table.
>>
>>
>>
On Tue, Sep 10, 2013 at 10:37 AM, Chris Curvey
wrote:
>
>
>
>
> Great thought. Looking through the logs, it appears that all my failures
> are on a CREATE INDEX. Usually on my biggest table, but often on another
> table.
>
>
>
> 2013-09-10 10:09:46 EDT ERROR: canceling autovacuum task
>
> 2013-
On 09/10/2013 10:37 AM, Chris Curvey wrote:
Another development (possibly unrelated): I tried **dumping** with
–no-privileges –no-tablespace –no-owner, and the restore went fine.
Probably has to do with whether you are dumping plain text or custom format:
http://www.postgresql.org/docs/9.2
On Tue, Sep 10, 2013 at 6:57 AM, Chris Curvey
wrote:
> From: Marcin Mańk [mailto:marcin.m...@gmail.com]
>
>
> > Is it crashing on a specific database object? pg_restore -v will tell
you
> > how far it went. Then try to restore only that object. Is it perhaps
> > crashing on a specific row?
> >
>
>
From: Jeff Janes [mailto:jeff.ja...@gmail.com]
Sent: Tuesday, September 10, 2013 1:26 PM
To: Chris Curvey
Cc: Marcin Mańk; pgsql-general@postgresql.org
Subject: Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?
On Tue, Sep 10, 2013 at 6:57 AM, Chris Curvey
mailto:ccur
> >
> > Good advice. I turned on –verbose, and got a ton of output, ending with:
> >
> > pg_restore: setting owner and privileges for FK CONSTRAINT
> > user_id_refs_id_7ceef80f
> >
> > pg_restore: setting owner and privileges for FK CONSTRAINT
> > user_id_refs_id_dfbab7d
> >
> > pg_restore: [archi
On 09/10/2013 06:57 AM, Chris Curvey wrote:
*From:*Marcin Mańk [mailto:marcin.m...@gmail.com]
*Sent:* Monday, September 09, 2013 8:30 PM
*To:* Chris Curvey
*Cc:* pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?
On Mon, Sep 9, 2013 at 4:00
From: Marcin Mańk [mailto:marcin.m...@gmail.com]
Sent: Monday, September 09, 2013 8:30 PM
To: Chris Curvey
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?
On Mon, Sep 9, 2013 at 4:00 PM, Chris Curvey
mailto:ccur...@zuckergoldberg.com
On Mon, Sep 9, 2013 at 4:00 PM, Chris Curvey wrote:
> But I'm having troubles with the 9.2 server crashing when I'm restoring
> the dump. I'm using the 9.2 version of pg_dump. I've tried restoring a
> custom-format dump with pg_restore, and I've tried restoring a text-format
> dump with pqsl, a
On 9/9/2013 4:53 PM, John R Pierce wrote:
On 9/9/2013 7:00 AM, Chris Curvey wrote:
any idea where I go from here?
don't develop on a newer version of the database than you are
deploying on.
*maybe* you can use the pgdump from 8.4 to connect to and dump the 9.2
database, but the 9.2 dump is
On 9/9/2013 7:00 AM, Chris Curvey wrote:
any idea where I go from here?
don't develop on a newer version of the database than you are deploying on.
*maybe* you can use the pgdump from 8.4 to connect to and dump the 9.2
database, but the 9.2 dump is NOT guaranteed to generate 8.4 compatible
S
wooo, thanks for all of your advice
it seems to be ok now!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Help-How-to-start-the-server-tp5756725p5757271.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing li
On 24/05/2013 08:35, YuChi wrote:
> i use postgresql-9.2.4 install on ubuntu11.04(natty)
> and i use the command:
>
> *postgres@ubuntu:/$ postgres -D /usr/local/pgsql/data*
>
> or use
>
> *postgres@ubuntu:/$ /usr/local/pgsql/bin/postmaster -D
> /usr/local/pgsql/data*
>
> to start the server
>
On 05/24/2013 12:35 AM, YuChi wrote:
i use postgresql-9.2.4 install on ubuntu11.04(natty)
and i use the command:
*postgres@ubuntu:/$ postgres -D /usr/local/pgsql/data*
or use
*postgres@ubuntu:/$ /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data*
to start the server
but it's stopping at
2013/5/24 YuChi :
> i use postgresql-9.2.4 install on ubuntu11.04(natty)
> and i use the command:
>
> *postgres@ubuntu:/$ postgres -D /usr/local/pgsql/data*
>
> or use
>
> *postgres@ubuntu:/$ /usr/local/pgsql/bin/postmaster -D
> /usr/local/pgsql/data*
>
> to start the server
> but it's stopping at
Hi, Davis.
I guess that the database was restarted by [pg_ctl restart -m fast] but
there was a continuous request from remote servers.
> (1)
> Does this prove or strongly indicate that somebody did a [pg_ctl_restart]
?
>
Yes. It seems that someone did [pg_ctl restart -m fast].
When the option
IIRC, service failure creates some event logs information in windows. And
also you can verify the bit rock installer log files from %TEMP% location.
Regards,
Dinesh
manojadinesh.blogspot.com
On Mon, Mar 25, 2013 at 5:05 PM, jayaram s <123jaya...@gmail.com> wrote:
> Hello
> I have installed Postg
On 3/25/2013 7:35 AM, jayaram s wrote:
Hello
I have installed PostgreSQL 8.4.1 in my PC. For the requirement of data
migration I again want to install "PostgreSQL enterprise DB 9.2".
I couldn't install it because
I have select option "postgresql compatible" on "configuration mode". So
prompt wan
On Thu, Oct 25, 2012 at 02:39:09AM -0200, Aníbal Pacheco wrote:
> I could after some work, what I want to ask now is this:
> In the middle of the pg_restore process I had to stop it (^Z) and remove one
> problematic and not needed database from the generated pg_upgrade_dump_db.sql
> file and then c
I could after some work, what I want to ask now is this:
In the middle of the pg_restore process I had to stop it (^Z) and remove
one problematic and not needed database from the
generated pg_upgrade_dump_db.sql file and then continue the process with
fg, of course it failed BUT: I started the new
Am 2012-10-15 23:13, schrieb John R Pierce:
On 10/15/12 2:03 PM, Daniel Serodio (lists) wrote:
John R Pierce wrote:
On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote:
3) Estimate the size of the transaction log
** We've got no idea how to estimate this, need advice **
postgres doesn't ha
On 2012-10-15, Daniel Serodio (lists) wrote:
>>
>> OID is optional, IIRC PGXID is not
> I hadn't heard of PGXID, I've just searched Google but found no
> reference to this term except for this e-mail thread and some source
> code. What is PGXID? Where can I learn more about hit?
That was the wr
GMAIL wrote:
> i describe the situation:
> i have two pc with postgressql server:
> - a main pc, with ip 192.168.5.1 turned on
> - a "backup" pc, with ip 192.168.5.1 turned off
>
> i want that the main pc saves the database in local hard drive and on
a
> nas real-time. when the main pc has a failu
On 10/15/12 2:03 PM, Daniel Serodio (lists) wrote:
John R Pierce wrote:
On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote:
3) Estimate the size of the transaction log
** We've got no idea how to estimate this, need advice **
postgres doesn't have a 'transaction log', it has the WAL
(Wri
John R Pierce wrote:
On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote:
3) Estimate the size of the transaction log
** We've got no idea how to estimate this, need advice **
postgres doesn't have a 'transaction log', it has the WAL (Write-Ahead
Logs). These are typically 16MB each. on
Jasen Betts wrote:
On 2012-10-08, Daniel Serodio (lists) wrote:
We are preparing a PostgreSQL database for production usage and we need
to estimate the storage size for this database. We're a team of
developers with low expertise on database administration, so we are
doing research, reading man
On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote:
3) Estimate the size of the transaction log
** We've got no idea how to estimate this, need advice **
postgres doesn't have a 'transaction log', it has the WAL (Write-Ahead
Logs). These are typically 16MB each. on databases with a reall
On 2012-10-08, Daniel Serodio (lists) wrote:
> We are preparing a PostgreSQL database for production usage and we need
> to estimate the storage size for this database. We're a team of
> developers with low expertise on database administration, so we are
> doing research, reading manuals and us
On 09/10/12 09:39, Daniel Serodio (lists) wrote:
We are preparing a PostgreSQL database for production usage and we
need to estimate the storage size for this database. We're a team of
developers with low expertise on database administration, so we are
doing research, reading manuals and using
Em 07/10/2012 02:46, Andreas Kretschmer escreveu:
Edson Richter wrote:
Dear friends,
I'm using Java 1.6 with Jdbc 4 driver with PostgreSQL 9.1.5 on Windows
64 and Linux 64.
Trying to use setQueryTimeout(int), I get the following stack trace:
Internal Exception: org.postgresql.util.PSQLExcepti
Edson Richter wrote:
> Dear friends,
>
> I'm using Java 1.6 with Jdbc 4 driver with PostgreSQL 9.1.5 on Windows
> 64 and Linux 64.
> Trying to use setQueryTimeout(int), I get the following stack trace:
> Internal Exception: org.postgresql.util.PSQLException: Method
> org.postgresql.jdbc4.Jdbc
On Jul 14, 2012, at 2:19 PM, Peter Geoghegan wrote:
> On 14 July 2012 18:56, Tom Lane wrote:
>> I can no longer reproduce a failure when building out-of-tree from a
>> tarball on my Fedora 16 box. That's still make 3.82, but Fedora is
>> carrying half a dozen patches to the upstream tarball:
>>
On 14 July 2012 18:56, Tom Lane wrote:
> I can no longer reproduce a failure when building out-of-tree from a
> tarball on my Fedora 16 box. That's still make 3.82, but Fedora is
> carrying half a dozen patches to the upstream tarball:
> http://pkgs.fedoraproject.org/gitweb/?p=make.git;a=tree;h=r
Peter Geoghegan writes:
> On 14 July 2012 16:57, Perry Smith wrote:
>> I hit "bug 5665". I see threads like this:
>>
>> http://archives.postgresql.org/pgsql-bugs/2011-01/msg00241.php
>>
>> Where / how can I find the diff that went in to fix this? Mostly I'm
>> curious. I can work around the
On 14 July 2012 16:57, Perry Smith wrote:
> I hit "bug 5665". I see threads like this:
>
> http://archives.postgresql.org/pgsql-bugs/2011-01/msg00241.php
>
> Where / how can I find the diff that went in to fix this? Mostly I'm
> curious. I can work around the problem but wanted to create a pat
On Sat, Jul 7, 2012 at 11:48 PM, Perry Smith wrote:
> The database is mostly static. I run through a very lengthy process to
> populate the database maybe once a month and then it is 99% read-only.
Do you run an ANALYZE on the table after populating it? Postgres needs
up-to-date statistics for
On Jul 6, 2012, at 7:56 PM, Steve Crawford wrote:
> On 07/06/2012 02:34 PM, Perry Smith wrote:
>> Hi Guys,
>>
>> This isn't a PostgreSQL specific question but just a SQL question. If this
>> is not an appropriate question for this list, please let me know.
>>
>> It is also, perhaps, a really
On 07/06/2012 02:34 PM, Perry Smith wrote:
Hi Guys,
This isn't a PostgreSQL specific question but just a SQL question. If this is
not an appropriate question for this list, please let me know.
It is also, perhaps, a really silly question.
This query (without the 'explain' keyword) , when exe
On 07/06/2012 03:34 PM, Perry Smith wrote:
Hi Guys,
This isn't a PostgreSQL specific question but just a SQL question. If this is
not an appropriate question for this list, please let me know.
It is also, perhaps, a really silly question.
This query (without the 'explain' keyword) , when exe
On 06/25/2012 09:27 PM, Alban Hertroys wrote:
Yes, pg_dump output from 8.3 should restore fine to 9.1.
Pardon my ignorance if this changed in recent versions, but shouldn't that read:
Yes, pg_dump 9.1 output from 8.3 should restore fine to 9.1?
Very good point and an important catch. Thank-you.
> Yes, pg_dump output from 8.3 should restore fine to 9.1.
Pardon my ignorance if this changed in recent versions, but shouldn't that read:
Yes, pg_dump 9.1 output from 8.3 should restore fine to 9.1?
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
On 06/25/2012 08:02 PM, Anibal David Acosta wrote:
We plan to upgrade to version 9.1, do you know if file result of the
pg_dump in 8.3 can be restored in 9.1?
Yes, pg_dump output from 8.3 should restore fine to 9.1. PLEASE READ THE
RELEASE NOTES for the intermediate major versions (8.4 and
havendra'; pgsql-general@postgresql.org
Asunto: Re: [GENERAL] Help, server doesn't start
On 06/25/2012 12:40 PM, Anibal David Acosta wrote:
Yes, we must upgrade.
The value of the shared_preload_libraries is
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll
postgresql.org
Asunto: Re: [GENERAL] Help, server doesn't start
On 06/25/2012 12:40 PM, Anibal David Acosta wrote:
Yes, we must upgrade.
The value of the shared_preload_libraries is
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'
# (c
On 06/25/2012 12:40 PM, Anibal David Acosta wrote:
Yes, we must upgrade.
The value of the shared_preload_libraries is
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' #
(change requires restart)
Change that to:
shared_preload_libraries = ''
(two single quotes, not a doubl
On Mon, Jun 25, 2012 at 10:10 AM, Anibal David Acosta wrote:
> Yes, we must upgrade.
>
> The value of the shared_preload_libraries is
>
> ** **
>
> shared_preload_libraries =
> '$libdir/plugins/plugin_debugger.dll' #
> (change requires restart)
>
> **
>
F
aghavendra@enterprisedb.com]
Enviado el: lunes, 25 de junio de 2012 12:31 a.m.
Para: Anibal David Acosta
CC: pgsql-general@postgresql.org
Asunto: Re: [GENERAL] Help, server doesn't start
On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta
wrote:
We have an old postgres installation (
El 24/06/2012 11:30 p.m., René Romero Benavides escribió:
El 24/06/2012 09:53 p.m., Anibal David Acosta escribió:
We have an old postgres installation (8.3) running on windows 2003
The server run perfect for many years but today it crash L
We have a very old backup so I'll try desperate to re
On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta wrote:
> We have an old postgres installation (8.3) running on windows 2003
>
> The server run perfect for many years but today it crash L
>
> ** **
>
> We have a very old backup so I’ll try desperate to repair.
>
> If I can’t repai
El 24/06/2012 09:53 p.m., Anibal David Acosta escribió:
We have an old postgres installation (8.3) running on windows 2003
The server run perfect for many years but today it crash L
We have a very old backup so I'll try desperate to repair.
If I can't repair I want to skip the error and start
Le lundi 21 mai 2012 15:35:55, Luca Ferrari a écrit :
> Hi all,
> I don't fully understand how is the cost of a bitmap heap scan
> computed. For instance when the explain output node is similar to the
> following:
>
> Bitmap Heap Scan on test (cost=17376.49..48595.93 rows=566707 width=6)
>Re
On 04/09/12 12:40 PM, François Beausoleil wrote:
It depends on whether you have a SQL dump file or a custom archive type. I
believe pg_restore can restore both kinds.
no, pg_restore can only restore from custom archives (made with pg_dump
-Fc) . straight SQL dumps are fed to psql
--
john
Le lundi 9 avril 2012 à 12:47, Lux a écrit :
> Hi,
> I am new to Postgresql and have no clue. The first task given to me was to
> try to mount this dmp file on Postgresql which has been downloaded from Jive.
> I am not sure how to go about and where to start. Can someone please help me.
> Than
101 - 200 of 828 matches
Mail list logo