Michael Satterwhite mich...@weblore.com writes:
On Monday, December 27, 2010 12:58:40 pm Guillaume Lelarge wrote:
Le 27/12/2010 18:57, Michael Satterwhite a écrit :
I'm obviously missing something ... and probably something obvious. Why
is date2 still null?
I'm not sure it'll help you. I
On 26 Nov 2010, at 6:04, Leif Jensen wrote:
Looking at your query, I'm kind of wondering why you're not letting the
database do the time-zone calculations?
But, that's not what your question was about:
I have concentrate my effort on the (double) 'Seq Scan':
Hello,
did you also try defininig partial indexes?
e.g.
CREATE INDEX xx on task_definitions (ctrlid) WHERE (name::text = 'UseWSData')
CREATE INDEX yy on ctrl_definitions (ctrlid) WHERE (name::text =
'IrrPeriodStart')
HTH,
Marc Mamin
-Original Message-
From:
From the shell, I use something like this :
psql -d datebasename -U username -c COPY tablename FROM 'datefile' WITH
DELIMITER ',' NULL '' ;
You'll have to add the path to the psql binary and to the csv file
-Original Message-
From: pgsql-general-ow...@postgresql.org
Can you open the specified URL in the browser?
On Nov 12, 2010, at 4:24 PM, ray wrote:
I just downloaded 9.0 onto my laptop and desktop Windows XP
machines. .Nether one could run the stack builder. Windows would
fault any time I tried to run it. I tried inputing the proxy server
but that
On Nov 12, 10:03 am, sachin.srivast...@enterprisedb.com (Sachin
Srivastava) wrote:
Can you open the specified URL in the browser?
On Nov 12, 2010, at 4:24 PM, ray wrote:
I just downloaded 9.0 onto my laptop and desktop Windows XP
machines. .Nether one could run the stack builder. Windows
On 20 October 2010 23:52, Dennis Gearon gear...@sbcglobal.net wrote:
Regarding the previously discussed triggers on tables to keep track of count:
http://www.varlena.com/GeneralBits/120.php
http://www.varlena.com/GeneralBits/49.php
from article
CREATE OR REPLACE FUNCTION count_rows()
RETURNS
Well, when I did something similar a very long time ago, I put a next time to
fire column in the table. Each time an event is fired, the application updates
that column.
Was a lot simpler than baroque searches for events that would need firing
between the last check and now. Was a lot cleaner
Scot Kreienkamp skre...@la-z-boy.com writes:
We have a PG 8.3.7 server that is doing WAL log shipping to 2 other
servers that are remote mirrors. This has been working well for almost
two years. Last night we did some massive data and structure changes to
one of our databases. Since then I
Scot Kreienkamp skre...@la-z-boy.com writes:
I tried to take a new base backup about 45 minutes ago. The master has
rolled forward a number of WAL files since I last tried, but it still
fails.
LOG: restored log file 0001030100FE from archive
LOG: restored log file
Scot Kreienkamp skre...@la-z-boy.com writes:
We have a PG 8.3.7 server that is doing WAL log shipping to 2 other
servers that are remote mirrors. This has been working well for
almost
two years. Last night we did some massive data and structure changes
to
one of our databases. Since then I
Shouldn't have, the only thing we did to the server was restart it and
run our database queries. Clearing out all the wal files from pg_xlog
along with a new base backup did fix it though.
Thanks for the help Tom!
Scot Kreienkamp
skre...@la-z-boy.com
--
Sent via pgsql-general mailing list
On 14/09/2010 11:02 AM, 夏武 wrote:
I reconvery it by \copy command.
thanks very much.
Glad to help.
In future, it might be a good idea to:
- Keep regular pg_dump backups; and
- Avoid trying to alter the system catalogs
With Slony you can never completely avoid needing to mess with the
On 11/09/10 14:21, 夏武 wrote:
i use the slony for replication of postgresql database. it work fine
some day.
After i use the slony command to delete the replication node, pg_dump
does not work, the error message is:
*pg_dump: schema with OID 73033 does not exist*
Then i delete the name
On 08/08/10 20.47, Jose Maria Terry wrote:
Hello all,
I need to run a query on a table that holds logged data from several
water flow meters.
I need the first and last values (with their associated time) for every
logger in a time range.
I've tried this that returns the min and max time in
El 08/08/10 21:49, Edoardo Panfili escribió:
On 08/08/10 20.47, Jose Maria Terry wrote:
Hello all,
I need to run a query on a table that holds logged data from several
water flow meters.
I need the first and last values (with their associated time) for every
logger in a time range.
I've
I tried it on my T-Mobile G1, stock 1.6 Android firmware. It downloaded and
installed fine, but right after installation, I clicked to open and got an
error box saying ... has encountered an unexpected error and closed.
But pgQuilt did install successfully, and when I go to my menu of
Many thanks for the feedback. I'll look into the problem after
installing. My first suspicion is that it is due to not having had
preferences set.
I agree about jdbc settings, I was rushing to get it out for some
testing. Likewise the menu, though that is also due to developing
using the
Hello.
First,we can not execute the SQL which Paulo indicated in PostgreSQL.
See this manual.
==
http://www.postgresql.org/docs/8.4/interactive/sql-update.html
Compatibility
This command conforms to the SQL standard, except
Hello,
While I can't answer my question, I am afraid I did not understand your
intentions either. The update you mentioned may not return consistent
results, isn't it? You are not ordering the data in any particular manner
and there is no unique column either. So the result of the update will
On Sat, May 22, 2010 at 8:02 AM, Deepa Thulasidasan
deepatulsida...@yahoo.co.in wrote:
Dear All,
Can some one help me understand st_azimuth() available in postgis.
did you read the documentation?
(http://postgis.refractions.net/documentation/manual-svn/ST_Azimuth.html).
the function
Excerpts from Gordon Shannon's message of mié may 19 11:49:45 -0400 2010:
at: last analysis tuples = pg_class.reltuples
I'm the least confident about the last one -- tuples as of last analyze.
Can anyone confirm or correct these?
In 8.4 it's number of dead + lives tuples that there
alvherre wrote:
Excerpts from Gordon Shannon's message of mié may 19 11:49:45 -0400 2010:
at: last analysis tuples = pg_class.reltuples
I'm the least confident about the last one -- tuples as of last analyze.
Can anyone confirm or correct these?
In 8.4 it's number of dead +
Excerpts from Gordon Shannon's message of mié may 19 18:02:51 -0400 2010:
I'm sorry, I'm not following you. Are you saying that last analysis
tuples is number of dead + live tuples from the previous anlyze? If so,
that would really confuse me because X would always be 0:
X = lt + dt - at
alvherre wrote:
n_live_tup and n_dead_tup corresponds to the current numbers,
whereas last analysis tuples are the values from back when the
previous analyze ran. These counters keep moving per updates, deletes,
inserts, they are not static.
OK. Do you know how can I get the values
Excerpts from Gordon Shannon's message of mié may 19 23:32:07 -0400 2010:
alvherre wrote:
n_live_tup and n_dead_tup corresponds to the current numbers,
whereas last analysis tuples are the values from back when the
previous analyze ran. These counters keep moving per updates, deletes,
2010/4/19 Đỗ Ngọc Trí Cường semin...@gmail.com
Dear all,
I've a problem but I search all the help file and can't find the solution.
I want to track all action of a specify role on all or one schema in
database.
Can you help me?
Thanks a lot and Best Regard,
Setup your log_line_prefix
On Apr 24, 4:13 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
Sam s...@palo-verde.us writes:
A particular web application I am working has a staging version
running one a vps, and a production version running on another vps.
They both get about the same usage, but the production version keeps
On Apr 24, 3:53 pm, thombr...@gmail.com (Thom Brown) wrote:
On 24 April 2010 18:48, Sam s...@palo-verde.us wrote:
Hi,
I am a web developer, I've been using postgesql for a few years but
administratively I am a novice.
A particular web application I am working has a staging version
On Apr 24, 3:53 pm, thombr...@gmail.com (Thom Brown) wrote:
On 24 April 2010 18:48, Sam s...@palo-verde.us wrote:
Hi,
I am a web developer, I've been using postgesql for a few years but
administratively I am a novice.
A particular web application I am working has a staging version
On 24 April 2010 18:48, Sam s...@palo-verde.us wrote:
Hi,
I am a web developer, I've been using postgesql for a few years but
administratively I am a novice.
A particular web application I am working has a staging version
running one a vps, and a production version running on another vps.
Sam s...@palo-verde.us writes:
A particular web application I am working has a staging version
running one a vps, and a production version running on another vps.
They both get about the same usage, but the production version keeps
crashing and has to be re-started daily for the last couple
2010/4/18 Craig Ringer cr...@postnewspapers.com.au:
Đỗ Ngọc Trí Cường wrote:
Dear all,
I've a problem but I search all the help file and can't find the solution.
I want to track all action of a specify role on all or one schema in
database.
Can you help me?
You can use statement-level
On Tue, 2010-04-20 at 06:03 -0600, Scott Marlowe wrote:
Wouldn't this work:
alter user smarlowe set log_statement = 'all';
IIRC it only works inside the given session (so it needs to be run each
time a query will be executed)
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat
On Tue, Apr 20, 2010 at 6:11 AM, Devrim GÜNDÜZ dev...@gunduz.org wrote:
On Tue, 2010-04-20 at 06:03 -0600, Scott Marlowe wrote:
Wouldn't this work:
alter user smarlowe set log_statement = 'all';
IIRC it only works inside the given session (so it needs to be run each
time a query will be
On Tue, Apr 20, 2010 at 8:31 AM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Apr 20, 2010 at 6:11 AM, Devrim GÜNDÜZ dev...@gunduz.org wrote:
On Tue, 2010-04-20 at 06:03 -0600, Scott Marlowe wrote:
Wouldn't this work:
alter user smarlowe set log_statement = 'all';
IIRC it only works
On 20/04/2010 10:33 PM, Scott Marlowe wrote:
psql
show log_statement;
log_statement
---
all
Note however that other sessions won't see the change. Only
connections that come after the change will see it.
Also, as the OP wants to use it for auditing, it's worth noting that
Craig Ringer wrote:
On 20/04/2010 10:33 PM, Scott Marlowe wrote:
psql
show log_statement;
log_statement
---
all
Note however that other sessions won't see the change. Only
connections that come after the change will see it.
Also, as the OP wants to use it for auditing,
On 21/04/2010 8:10 AM, Steve Crawford wrote:
From the docs for log_statement: Only superusers can change this
setting.
Argh. Thankyou.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Đỗ Ngọc Trí Cường wrote:
Dear all,
I've a problem but I search all the help file and can't find the solution.
I want to track all action of a specify role on all or one schema in
database.
Can you help me?
You can use statement-level logging, though there are no facilities in
Craig Ringer wrote:
Đỗ Ngọc Trí Cường wrote:
Dear all,
I've a problem but I search all the help file and can't find the solution.
I want to track all action of a specify role on all or one schema in
database.
Can you help me?
You can use statement-level logging, though there are no
Yeb Havinga wrote:
Craig Ringer wrote:
Đỗ Ngọc Trí Cường wrote:
Dear all,
I've a problem but I search all the help file and can't find the
solution.
I want to track all action of a specify role on all or one schema in
database.
Can you help me?
You can use statement-level
On 29/03/2010 15:43, 赤松 建司 wrote:
help
Surely. What with? :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 24 March 2010 05:17, Nilesh Govindarajan li...@itech7.com wrote:
On 03/24/2010 12:45 AM, Dean Rasheed wrote:
On 23 March 2010 11:07, Nilesh Govindarajanli...@itech7.com wrote:
Hi,
I want to find out the userid, nodecount and comment count of the userid.
I'm going wrong somewhere.
On 03/24/2010 01:14 PM, Dean Rasheed wrote:
On 24 March 2010 05:17, Nilesh Govindarajanli...@itech7.com wrote:
On 03/24/2010 12:45 AM, Dean Rasheed wrote:
On 23 March 2010 11:07, Nilesh Govindarajanli...@itech7.comwrote:
Hi,
I want to find out the userid, nodecount and comment count
On 23 March 2010 11:07, Nilesh Govindarajan li...@itech7.com wrote:
Hi,
I want to find out the userid, nodecount and comment count of the userid.
I'm going wrong somewhere.
Check my SQL Code-
select u.uid, count(n.nid) nc , count(c.cid) cc from users u left join node
n on ( n.uid = u.uid
On 03/24/2010 12:45 AM, Dean Rasheed wrote:
On 23 March 2010 11:07, Nilesh Govindarajanli...@itech7.com wrote:
Hi,
I want to find out the userid, nodecount and comment count of the userid.
I'm going wrong somewhere.
Check my SQL Code-
select u.uid, count(n.nid) nc , count(c.cid) cc from
In response to Jay :
Thanks!
But, since the master can contain many users (user2, user3, and so on)
I suppose this won't be a proper solution?
Sorry if I was a bit unclear in my description.
I.e., the master is of the form:
user_id date
User1 20010101
User1 2101
User1 19990101
Jay josip.2...@gmail.com wrote:
Hi,
I'm somewhat new to SQL so I need a bit of help with this problem. So
I have 2 tables: selection and master, both have two columns in
each: user_id and date.
The selection contains one row for each user_id and depicts _one_
date value for each user.
Thanks!
But, since the master can contain many users (user2, user3, and so on)
I suppose this won't be a proper solution?
Sorry if I was a bit unclear in my description.
I.e., the master is of the form:
user_id date
User1 20010101
User1 2101
User1 19990101
User1 19970101
User2 ...
...
Btw,
CORRECTION:
The original selection should be:
User1 2101
NOT
User1 19990101
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: John R Pierce [mailto:pie...@hogranch.com]
Sent: Thursday, February 11, 2010 3:01 PM
To: pgsql-general@postgresql.org
Subject: Re: help with SQL join
Neil Stlyz wrote:
Now... here is the problem I am having... the above SQL query is
retrieving
Neil Stlyz wrote:
Now... here is the problem I am having... the above SQL query is
retrieving results from one table: sales
I have another table called customers with a couple of fields
(customerid, and customername are two of the fields).
I want to join on the customerid in both tables to
On 25/01/2010 12:21 PM, Steeles wrote:
As title, please help.
I want to setup Postgresql HA by MSCS in VMWARE platform. (win server
2003, PG 8.3 on 32 bit)
MSCS has been setup, the problem can't start postgresql service.
PGDATA is on the shared disk.
Are you trying to share a PostgreSQL data
2010/1/25 Craig Ringer cr...@postnewspapers.com.au:
On 25/01/2010 12:21 PM, Steeles wrote:
As title, please help.
I want to setup Postgresql HA by MSCS in VMWARE platform. (win server
2003, PG 8.3 on 32 bit)
MSCS has been setup, the problem can't start postgresql service.
PGDATA is on the
John R Pierce wrote:
Elian Laura wrote:
i understand, but why my teacher wrote in his paper..Probably the
most obvious case is a database engine where the user defines, at run
time, if a field is integer, char, float, etc. but, it is not
necessary to compile the program again. All this
Elian Laura wrote:
i understand, but why my teacher wrote in his paper..Probably the
most obvious case is a database engine where the user defines, at run
time, if a field is integer, char, float, etc. but, it is not
necessary to compile the program again. All this felxibility must be
2010/1/19 BlackMage dsd7...@uncw.edu:
Hey all,
I need help on constructing a query with arrays that matches the arrays up
as foriegn keys to another table. For example, say that I have two tables,
owners and pets.
Owner Table
owner_id | pet_ids
1 | {1,2,3}
2 |
Elian Laura wrote:
Hello,
I´m an undergraduate in Peru in systems engineering.
I need to know about how does postgres work with the definition of
data type in run time.
I downloaded de source code of postgres, but es very complex, at least
I would like to know in which part of the code is the
On 7/12/2009 3:00 PM, A B wrote:
Hi.
I just logged into a system and found this in the log when trying to
start postgres.
Possibly silly question: is there plenty of free disk space on the file
system where PostgreSQL's data is stored?
--
Craig Ringer
--
Sent via pgsql-general mailing list
Craig Ringer cr...@postnewspapers.com.au writes:
On 7/12/2009 3:00 PM, A B wrote:
I just logged into a system and found this in the log when trying to
start postgres.
Possibly silly question: is there plenty of free disk space on the file
system where PostgreSQL's data is stored?
That's
marco di antonio wrote:
Hi,
I downloaded the portable version of Postegresql from
http://greg.webhop.net/postgresql_portable
It works but the problem is that to start the server you must load it
from the gui. Instead since I want to start the server from my app, I
need to understand how to
John R Pierce wrote on 06.12.2009 00:01:
I downloaded the portable version of Postegresql from
http://greg.webhop.net/postgresql_portable
It works but the problem is that to start the server you must load it
from the gui. Instead since I want to start the server from my app, I
need to
Solved. For now.
- LOG: could not open directory G:/mysql/pgsql/share/timezone: No
such file or directory
I copied this folder from another postgres installation i did some
months back on another system and wham, up and running agan.
weird.
--
On Sun, Nov 29, 2009 at 11:27 AM, CyTG
I wish the solution was that simple. I rent the zone and that is my
providers cap.
On 2-Nov-09, at 5:21 PM, Scott Marlowe wrote:
On Mon, Nov 2, 2009 at 1:11 PM, Brooks Lyrette brooks.lyre...@gmail.com
wrote:
Thanks for all the help guys.
So this is what I get from all this. My solaris zone
Thanks for all the help guys.
So this is what I get from all this. My solaris zone will cap me at
around 900M-1000M RSS memory. Therefore using the math from a pervious
reply I can only have about 23 connections to my database without
maxing out the machines memory?
This seems a little
On Mon, Nov 2, 2009 at 1:11 PM, Brooks Lyrette brooks.lyre...@gmail.com wrote:
Thanks for all the help guys.
So this is what I get from all this. My solaris zone will cap me at around
900M-1000M RSS memory. Therefore using the math from a pervious reply I can
only have about 23 connections to
On Mon, Nov 2, 2009 at 3:56 PM, Brooks Lyrette brooks.lyre...@gmail.com wrote:
I wish the solution was that simple. I rent the zone and that is my
providers cap.
Am I misunderstanding this? You rent an image with 32Gigs of ram.
Your provider limits you to any single process / application being
2009/10/28 Brooks Lyrette brooks.lyre...@gmail.com:
Hello All,
I'm new to postgres and it seems my server is unable to fork new
connections.
Here is the log:
LOG: could not fork new process for connection: Not enough space
LOG: could not fork new process for connection: Not enough space
2009/10/28 Brooks Lyrette brooks.lyre...@gmail.com:
There should be no other processes running, this system is dedicated to
running postgresql.
Max connections is configured to: max_connections = 400
Well it sounds like you've somehow run out of swap space. Are you
able to run top and sort
Brooks Lyrette brooks.lyre...@gmail.com writes:
I'm new to postgres and it seems my server is unable to fork new
connections.
LOG: could not fork new process for connection: Not enough space
For what I suppose is a lightly loaded machine, that is just plain
weird. What's the platform
The machine is running a moderate load. This is running on a Solaris
Zone.
Top is showing:
load averages: 2.49, 4.00, 3.78;up
124
+
12
:
24
:
47
There should be no other processes running, this system is dedicated
to running postgresql.
Max connections is configured to: max_connections = 400
Brooks L.
On 28-Oct-09, at 3:46 PM, Thom Brown wrote:
2009/10/28 Brooks Lyrette brooks.lyre...@gmail.com:
Hello All,
I'm
On Wed, Oct 28, 2009 at 1:05 PM, Brooks Lyrette
brooks.lyre...@gmail.com wrote:
The machine is running a moderate load. This is running on a Solaris Zone.
Memory: 32G phys mem, 942M free mem, 76G swap, 74G free swap
PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
5069
On Wed, 28 Oct 2009, Tom Lane wrote:
What's the platform exactly? Is it possible that the postmaster is
being launched under very restrictive ulimit settings?
Now that Brooks mentioned this being run inside of a Solaris zone, seems
like this might be running into some memory upper limit
On Wed, 28 Oct 2009, Greg Stark wrote:
PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
5069 postgres 1 52 0 167M 20M sleep 0:04 13.50% postgres
Hm, well 400 processes if each were taking 190M would be 76G. But that
doesn't really make much sense since most of
Greg Smith gsm...@gregsmith.com writes:
On Wed, 28 Oct 2009, Tom Lane wrote:
What's the platform exactly? Is it possible that the postmaster is
being launched under very restrictive ulimit settings?
Now that Brooks mentioned this being run inside of a Solaris zone, seems
like this might
On Tuesday 22 September 2009 7:28:03 pm Joe Kramer wrote:
I have database backup schema+data in text (non-compressed) format.
Backup is created using pg_dump -i -h ... -U ... -f dump.sql.
I run it with psql dump.sql but after restore all triggers are disabled!
I can't use this text dump with
Joe Kramer cckra...@gmail.com writes:
I have database backup schema+data in text (non-compressed) format.
Backup is created using pg_dump -i -h ... -U ... -f dump.sql.
I run it with psql dump.sql but after restore all triggers are disabled!
You sure they weren't disabled in the source
On Thu, Sep 24, 2009 at 12:02 AM, Adrian Klaver akla...@comcast.net wrote:
On Tuesday 22 September 2009 7:28:03 pm Joe Kramer wrote:
I have database backup schema+data in text (non-compressed) format.
Backup is created using pg_dump -i -h ... -U ... -f dump.sql.
I run it with psql dump.sql
On Thu, Sep 24, 2009 at 12:53 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Joe Kramer cckra...@gmail.com writes:
I have database backup schema+data in text (non-compressed) format.
Backup is created using pg_dump -i -h ... -U ... -f dump.sql.
I run it with psql dump.sql but after restore all
Joe Kramer cckra...@gmail.com writes:
On Thu, Sep 24, 2009 at 12:02 AM, Adrian Klaver akla...@comcast.net wrote:
What version of Postgres are you dumping from, restoring to? Which version of
I am using client 8.1.9 to dump from server 8.3.0 (unable to use client
8.3.x)
Importing to server
Joe Kramer cckra...@gmail.com writes:
On Thu, Sep 24, 2009 at 12:53 AM, Tom Lane t...@sss.pgh.pa.us wrote:
You sure they weren't disabled in the source database?
Yes, I'm absolutely sure they are not disabled. And in the SQL dump
file there are no commands that would disable them.
Better
On Thu, Sep 24, 2009 at 1:33 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Joe Kramer cckra...@gmail.com writes:
On Thu, Sep 24, 2009 at 12:53 AM, Tom Lane t...@sss.pgh.pa.us wrote:
You sure they weren't disabled in the source database?
Yes, I'm absolutely sure they are not disabled. And in the SQL
- Joe Kramer cckra...@gmail.com wrote:
On Thu, Sep 24, 2009 at 1:33 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Joe Kramer cckra...@gmail.com writes:
On Thu, Sep 24, 2009 at 12:53 AM, Tom Lane t...@sss.pgh.pa.us
wrote:
You sure they weren't disabled in the source database?
Yes, I'm
On Wed, Sep 23, 2009 at 9:12 AM, Joe Kramer cckra...@gmail.com wrote:
I am using client 8.1.9 to dump from server 8.3.0 (unable to use client
8.3.x)
Importing to server 8.3.7.
That won't work
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
I can not find command in postgres - With ... as
You need Postgres 8.4 for that:
http://www.postgresql.org/docs/current/static/queries-with.html
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Thu, Aug 13, 2009 at 3:00 AM, Greg Smithgsm...@gregsmith.com wrote:
buffers_backend = 740
This number represents the behavior the background writer is trying to
prevent--backends having to clean their own buffers up.
so what we want on busy systems is buffers_backend to be (at least)
On Wed, 12 Aug 2009, sam mulube wrote:
is my interpreting of buffers_clean = 0 correct?
Yes.
If so, why would the bgwriter not be writing out any buffers?
The purpose of the cleaner is to prepare buffers that we expect will be
needed for allocations in the near future. Let's do a
On Wed, 2009-07-22 at 18:15 -0400, Robert James wrote:
I'd like to SELECT INTO one table into another one. However, I'd like
to do two things that I don't know how to do using SELECT INTO:
1. Copy over the indexes and constraints of the first table into the
second
See:
do the DB folders still exist? if so back them up, reinstall Postgres
(reinstalling XP probably wiped out either DLL's or registry entries)
and relaunch it. don't have it initialize a DB on install
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf
, 2009 1:18 PM
To: don2_...@yahoo.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Help me please...
do the DB folders still exist? if so back them up, reinstall Postgres
(reinstalling XP probably wiped out either DLL's or registry entries)
and relaunch it. don't have it initialize a DB
ja...@aers.ca wrote:
if you used default locations I believe it should be (this is from
memory mind) under c:\program files\postgres\version\data\
data is the folder you want.
First, verify the location of pgdata...
sc qc pgsql-8.3
(I'm assuming this is 8.3, modify for other
On Tue, 2009-06-30 at 17:58 +0200, Rosko C.A. wrote:
Hi. I'm trying to install Postgresql 8.3 in my computer but a windows
appear asking me a password that i no have... If I click next button
no continues... i don't know what can I do. Yesterday I tried to
install pokertracker 3 (the latest
What OS are you running?
What exactly is the window saying? If you could take a snapshot of it
and upload it to a photo site and send the URL to the list, that might
be helpful.
Most OSes allow you to snapshot the active window with CTRL-PRT-SCRN
Then you can use the paste option in your favorite
Success, of sorts. I was able to retrieve 90% the corrupted data by
dumping the heap file. Many thanks to those who replied with helpful
suggestions.
If you're interested in detail then read on. Otherwise, don't bother.
The data was still in the table -- I could see it using a hex editor.
On Tue, Jun 23, 2009 at 2:05 PM, Gus
Gutoskishared.entanglem...@gmail.com wrote:
Success, of sorts. I was able to retrieve 90% the corrupted data by
dumping the heap file. Many thanks to those who replied with helpful
suggestions.
If you're interested in detail then read on. Otherwise,
On Sun, Jun 14, 2009 at 10:32 AM, Gus
Gutoskishared.entanglem...@gmail.com wrote:
Merlin Moncure wrote:
postgresql 8.1 supports pitr archiving. you can
do continuous backups and restore the database to just before the bad
data.
I tried using point-in-time-recovery to restore the state of
Merlin Moncure wrote:
postgresql 8.1 supports pitr archiving. you can
do continuous backups and restore the database to just before the bad
data.
I tried using point-in-time-recovery to restore the state of the
database immediately before the corruption. It didn't work, but it
was quite a
On Sun, 2009-06-14 at 10:32 -0400, Gus Gutoski wrote:
0. Shortly after the corruption on June 9, 2009, I shut down the
server and backed up the entire data directory. The recovery
procedure described herein begins with this file system backup.
1. The most recent non-corrupted snapshot of the
301 - 400 of 807 matches
Mail list logo