On Sun, Jul 01, 2007 at 10:46:22PM -0300, Jorge Godoy wrote:
On Sunday 01 July 2007 22:25:24 Casey Crosbie wrote:
Jorge,
Thanks for the suggestion. But unfortunately, I tried both
\cd C:/Document~1 and just \cd C:/Document~1 and neither worked.
Sorry. It should be up to 8 chars:
Magnus Hagander wrote:
Yes, but it was not necessarily launched as msiexec. If the file was
just double-clicked on, the path to msiexec will be fetched from the
registry and not the system PATH. That's the only explanation I can find.
Not being installed on Windows 2000 is possible iirc - but
Harry Jackson wrote:
The following sql statement fails because the column user_id does
not exist in the users table.
=# select user_id from users WHERE username = 'blah';
ERROR: column user_id does not exist
LINE 1: select user_id from users WHERE username = 'blah..
am Mon, dem 02.07.2007, um 11:13:54 +0530 mailte Ashish Karalkar folgendes:
Hello All,
I am trying to create databse with script.
I run this script from root prompt with command
$ su - postgres -c 'path to script.sql'
In the script I follow following steps
1) create user
On Sun, 2007-07-01 at 21:41 -0700, Jason L. Buberel wrote:
I am trying to learn/practice the administrative steps that would need
to be taken in a 'fat finger' scenario, and I am running into problems.
I am trying to use 'recovery.conf' to set the database state to about 15
minutes ago in
... x should be y
I do get these messages one 2 of my servers running mostly on identical
data. The servers are unix-based and are running 8.1.8 under linux (Gentoo).
On one server the message appears only after vacuum-ing, on the other I
had some errors after inserting into the table too
Le jeudi 28 juin 2007, [EMAIL PROTECTED] a écrit :
Hello all -
I was looking for a way to find out how much disk space each table is
using.
As of PostgreSQL 8.1 you can use the following:
http://www.postgresql.org/docs/8.1/static/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE
Example query to
On Sun, Jul 01, 2007 at 10:39:01PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Maybe what is happening is that an entirely unrelated process created a
segment with that ID, attached to it, and then it was deleted. I don't
know how to check however.
AFAIK, EIDRM
Hi All,
I have eliminated certain tables while exporting as the size of the data in
the tables are huge.Though am having the schema which contains all the
tables.
Now I want to import limited set of records/rows ( 1000 tuples ) from the
eliminated tables.
Is this possible? If yes, please
Thanks for your replay.
I think the problem is with schema not being recognised.
following are the line from sql script:(This script is run as a postgres
user with password authntication from .pgpass file)
${PG_PATH}/createuser qsweb -S -d -R -l -P -E -q -U postgres
${PG_PATH}/createdb -E
Hi,
Le lundi 02 juillet 2007, cha a écrit :
Now I want to import limited set of records/rows ( 1000 tuples ) from the
eliminated tables.
Is this possible? If yes, please tell me how to accomplish this?
If you have CSV or CSV-like data file format, you can use pgloader with the -C
option,
Simon,
Thanks for the tip. I had assumed that so long as I set
'recovery_target_time' to a value that occurred before the 'fatal
commit' and set the 'inclusive' flag to false that I would be able to
return to just before the deletion occurred.
I'll play with it a bit more and see. I just
On Mon, Jul 02, 2007 at 01:05:35PM +0200, Martijn van Oosterhout wrote:
If it's installed, this:
lsof |grep SYSV
Will list all processes attached to a SHM segemtn on the system. I
think ipcs can do the same. You can grep /proc/*/maps for the same
info.
I already tried those; none show
Hi, we recently upgraded our Postgres instllation from 7.4 to 8.2 by
doing a dump and restore. Howveer after logging into the database (as
a user that is not the superuser) and doing \dt I get the error:
No relations found
But when I do
SELECT relname, relpages FROM pg_class ORDER BY
On Mon, Jul 02, 2007 at 11:46:54AM +0200, Gerhard Hintermayer wrote:
... x should be y
I do get these messages one 2 of my servers running mostly on identical
data. The servers are unix-based and are running 8.1.8 under linux (Gentoo).
On one server the message appears only after
On Mon, Jul 02, 2007 at 10:04:21AM -0400, Rajarshi Guha wrote:
Hi, we recently upgraded our Postgres instllation from 7.4 to 8.2 by
doing a dump and restore. Howveer after logging into the database (as
a user that is not the superuser) and doing \dt I get the error:
No relations found
Rajarshi Guha [EMAIL PROTECTED] writes:
Hi, we recently upgraded our Postgres instllation from 7.4 to 8.2 by
doing a dump and restore. Howveer after logging into the database (as
a user that is not the superuser) and doing \dt I get the error:
No relations found
But when I do
SELECT
On 7/2/07, Rajarshi Guha [EMAIL PROTECTED] wrote:
Hi, we recently upgraded our Postgres instllation from 7.4 to 8.2 by
doing a dump and restore. Howveer after logging into the database (as
a user that is not the superuser) and doing \dt I get the error:
No relations found
Are you using the
On Jul 2, 2007, at 10:04 AM, Rajarshi Guha wrote:
Hi, we recently upgraded our Postgres instllation from 7.4 to 8.2
by doing a dump and restore. Howveer after logging into the
database (as a user that is not the superuser) and doing \dt I get
the error:
No relations found
But when I do
Simon Riggs [EMAIL PROTECTED] writes:
On Sun, 2007-07-01 at 21:41 -0700, Jason L. Buberel wrote:
I am trying to learn/practice the administrative steps that would need
to be taken in a 'fat finger' scenario, and I am running into problems.
Your example transactions are so large that going
Gerhard Hintermayer [EMAIL PROTECTED] writes:
... x should be y
I do get these messages one 2 of my servers running mostly on identical
data. The servers are unix-based and are running 8.1.8 under linux (Gentoo).
Update.
http://developer.postgresql.org/pgdocs/postgres/release-8-1-9.html
Martijn van Oosterhout wrote:
On Mon, Jul 02, 2007 at 11:46:54AM +0200, Gerhard Hintermayer wrote:
... x should be y
I do get these messages one 2 of my servers running mostly on identical
data. The servers are unix-based and are running 8.1.8 under linux (Gentoo).
On one server the message
Tom Lane wrote:
Gerhard Hintermayer [EMAIL PROTECTED] writes:
... x should be y
I do get these messages one 2 of my servers running mostly on identical
data. The servers are unix-based and are running 8.1.8 under linux (Gentoo).
Update.
Harrumph -
I downloaded the latest xlogdump source, and built/installed it against
my 8.2.4 source tree. When I execute it however, I am informed that all
of my WAL files (either the 'active' copies in pg_xlog or the 'archived'
copies in my /pgdata/archive_logs dir) appear to be malformed:
Some more bits on this:
And playing with the date format does not seem to change the outcome
(the db is always recovered to the most current state). In this case, I
removed the timezone designation 'PDT' from my timestamp, and the db
properly figured out that it is running in GMT-7 (pacific)
This is not a question, but a solution. I just wanted to share this
with others on the list in case it saves you a few hours of searching...
I wanted to select several rows of data and have them returned in a
single record with the rows joined by a delimiter. Turns out this is
very easy to
On Mon, 2007-07-02 at 09:21 -0700, Jason L. Buberel wrote:
I downloaded the latest xlogdump source, and built/installed it against
my 8.2.4 source tree. When I execute it however, I am informed that all
of my WAL files (either the 'active' copies in pg_xlog or the 'archived'
copies in my
On Mon, 2007-07-02 at 11:06 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On Sun, 2007-07-01 at 21:41 -0700, Jason L. Buberel wrote:
I am trying to learn/practice the administrative steps that would need
to be taken in a 'fat finger' scenario, and I am running into problems.
Some time ago, Jon Lapham [EMAIL PROTECTED] wrote:
Today I had a power outage which upon reboot seems to have done
something to cause Postgresql to not restart properly. This has
happened to me before:
http://archives.postgresql.org/pgsql-general/2006-09/msg00938.php
We finally tracked
My first posting stalled because I posted from the wrong email account,
here is the new posting, plus some more info:
I have a user application use log.
Under pg 7.x the system performed fine.
In 8.1.9, the insert statements seem to take a long time sometimes, upto
several seconds or more.
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2007-07-02 at 09:21 -0700, Jason L. Buberel wrote:
I downloaded the latest xlogdump source, and built/installed it against
my 8.2.4 source tree. When I execute it however, I am informed that all
of my WAL files (either the 'active' copies in
Jason L. Buberel [EMAIL PROTECTED] writes:
What worries me is the 'record with zero length',
That's just the normal way of detecting end of WAL.
regards, tom lane
---(end of broadcast)---
TIP 2: Don't 'kill -9' the
Terry Fielder [EMAIL PROTECTED] writes:
Under pg 7.x the system performed fine.
In 8.1.9, the insert statements seem to take a long time sometimes, upto
several seconds or more.
There is no primary key, but the table is never updated, only inserted.
I removed the only index, with no
On Mon, 2007-07-02 at 16:32 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2007-07-02 at 09:21 -0700, Jason L. Buberel wrote:
I downloaded the latest xlogdump source, and built/installed it against
my 8.2.4 source tree. When I execute it however, I am informed that
During some time I have had more problems with invalid data in different
parts of a PostgreSQL database.
Until now it has been pointers to non present clog files and an index
file, but now it's in a data file.
I'm getting this error when doing a backup:
invalid page header in block 5377 of
I have a table of around 6,000 places in the world. Everytime my
server receives a ping, I'm grabbing the content of an article from an
RSS feed. Then I search the article for the presence of any the 6000
terms.
A typical article is around 1200 words.
I don't need to save the article in a
On Jul 2, 2007, at 3:36 PM, Postgres User wrote:
I have a table of around 6,000 places in the world. Everytime my
server receives a ping, I'm grabbing the content of an article from an
RSS feed. Then I search the article for the presence of any the 6000
terms.
A typical article is around
Tom Lane wrote:
Some time ago, Jon Lapham [EMAIL PROTECTED] wrote:
Today I had a power outage which upon reboot seems to have done
something to cause Postgresql to not restart properly. This has
happened to me before:
http://archives.postgresql.org/pgsql-general/2006-09/msg00938.php
We
Responses below.
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Tom Lane wrote:
Terry Fielder [EMAIL PROTECTED] writes:
Under pg 7.x the system performed fine.
In 8.1.9, the insert
On 06/18/07 08:05, Merlin Moncure wrote:
[snip]
That being said, it's pretty clear to me we are in the last days of
the disk drive.
Oh, puhleeze. Seagate, Hitachi, Fuji and WD aren't sitting around
with their thumbs up their arses.In 3-4 years, large companies
and spooky TLAs will be
On 06/25/07 09:58, Tom Lane wrote:
[snip]
The fly in the ointment is that if the column value is so high
cardinality as all that, it's questionable whether you want an index
search at all rather than just seqscanning; and it's definite that
the index access cost will be only a fraction of the
Thanks to you all for all your help and comments.
I finally ended up creating a trigger to check the constraints. This has the
added benefit that more than one constraint can be checked in the one
trigger.
As to whether it is the best model or not for what I want to do. This
question is more
I now have a working xlogdump, which has allowed me to put together the
following steps which I believe demonstrate that the recovery process
insists on recovering to the most recent state.
Here is the sequence of events shown below:
1. Display contents of 'account_note' table
2. Update note
Hi,
I had a similar problem and overcame it by temporarily setting
zero_damaged_pages, then doing a full vacuum and re-index on the affected table.
The rows contained in the corrupted page were lost but the rest of the table
was OK after this.
Regards // Mike
-Original Message-
From:
Minor correction to the output below - the final table dump actually
contained the following - my apologies for the copy/paste error:
altos_research=# select * from account_note;
account_note_id | customer_account_id | user_id_of_author |
creation_date | note
Jason L. Buberel [EMAIL PROTECTED] writes:
## stopped and started postgres, following syslog output:
You seem to have omitted all the interesting details about what you did
here; but stopping and starting postgres is certainly not intended to
cause it to discard data. There would need to have
I am now learning that fact, but recall the original scenario that I am
trying to mimic:
1. Person accidentally deletes contents of important table.
2. Admin (me) wants to roll back db state to just prior to that deletion.
3. (Me) Assumes that by creating a recovery.conf file and setting the
I think that I now see the error of my ways.
When I shutdown my server, the files under the ./data/ directory still
all point to 'now' and not 'a week ago when the backups were taken'. So
the recover process insists on bringing the database to a PITR equal to
'now'.
Instead, in order to
48 matches
Mail list logo