On 08/28/2014 09:14 PM, 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 what are the
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 can
: [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 in the yum
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
-
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 issues of 9.3
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 Compatibilities.
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
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
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 serge.fonvi...@gmail.com:
Hi,
2014-06-05 9:32 GMT-06:00 Carlos Carcamo eazyd...@gmail.com:
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
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.
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
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 serefari...@gmail.com 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
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?
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 then
Just a little, I will read it again, thanks for your help.
2014-06-05 10:39 GMT-06:00 David G Johnston david.g.johns...@gmail.com:
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
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. If
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
On Fri, Mar 28, 2014 at 12:45 PM, hari.fu...@gmail.com 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
Moshe Jacobson mo...@neadwerx.com 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
On Fri, Mar 28, 2014 at 12:21 PM, Igor Neyman iney...@perceptron.comwrote:
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
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
On Wed, Feb 5, 2014 at 5:21 AM, Edson Richter edsonrich...@hotmail.com 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
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
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
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
On Thu, Jan 23, 2014 at 3:46 PM, Bill Moran wmo...@potentialtech.com 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
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 it
On Fri, Jan 3, 2014 at 10:53 PM, denn...@visi.com wrote:
Index name idx_scan idx_tup_read idx_tup_fetch
idx1 1000
0
idx2 100 2000
idx3 100 200
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 Sun, Jan 5, 2014 at 2:19 PM, Gavin Flower
gavinflo...@archidevsys.co.nz 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.
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 gray...@gmail.com wrote:
On Sun, Jan 5, 2014 at 2:19 PM,
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
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
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 regards,
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
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.
I have 3
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,
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.
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
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
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
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
On Mon, Sep 30, 2013 at 10:03 AM, Carlos Eduardo Sotelo Pinto
carlos.sotelo.pi...@gmail.com 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
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,
On Tue, Sep 10, 2013 at 10:37 AM, Chris Curvey
ccur...@zuckergoldberg.comwrote:
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
On Sun, Sep 15, 2013 at 7:49 PM, Jeff Janes jeff.ja...@gmail.com wrote:
On Tue, Sep 10, 2013 at 10:37 AM, Chris Curvey ccur...@zuckergoldberg.com
wrote:
Great thought. Looking through the logs, it appears that all my failures
are on a CREATE INDEX. Usually on my biggest table, but
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
ccur...@zuckergoldberg.commailto:ccur
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
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: [archiver (db)] could not
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
ccur
On Tue, Sep 10, 2013 at 6:57 AM, Chris Curvey ccur...@zuckergoldberg.com
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
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:
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
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
On Mon, Sep 9, 2013 at 4:00 PM, Chris Curvey ccur...@zuckergoldberg.comwrote:
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
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
2013/5/24 YuChi tp6m4fu6250...@yahoo.com.tw:
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
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
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
but it's
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
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 wants me
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
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
On 2012-10-15, Daniel Serodio (lists) daniel.li...@mandic.com.br 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
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
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 failure, i
Jasen Betts wrote:
On 2012-10-08, Daniel Serodio (lists)daniel.li...@mandic.com.br 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
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
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
On 2012-10-08, Daniel Serodio (lists) daniel.li...@mandic.com.br 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,
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
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 edsonrich...@hotmail.com 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:
Edson Richter edsonrich...@hotmail.com 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
On 14 July 2012 16:57, Perry Smith pedz...@gmail.com 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
Peter Geoghegan pe...@2ndquadrant.com writes:
On 14 July 2012 16:57, Perry Smith pedz...@gmail.com 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
On 14 July 2012 18:56, Tom Lane t...@sss.pgh.pa.us 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 Jul 14, 2012, at 2:19 PM, Peter Geoghegan wrote:
On 14 July 2012 18:56, Tom Lane t...@sss.pgh.pa.us 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
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 silly
On Sat, Jul 7, 2012 at 11:48 PM, Perry Smith pedz...@gmail.com 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
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
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
: [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'
# (change requires restart)
Change
@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'
# (change requires restart)
Change
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
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 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.
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
On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta a...@devshock.comwrote:
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
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
@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 a...@devshock.com
wrote:
We have an old postgres installation
On Mon, Jun 25, 2012 at 10:10 AM, Anibal David Acosta a...@devshock.comwrote:
Yes, we must upgrade.
The value of the shared_preload_libraries is
** **
shared_preload_libraries =
'$libdir/plugins/plugin_debugger.dll' #
(change requires restart)
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
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)
Recheck
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.
Thanks
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
--
101 - 200 of 807 matches
Mail list logo