Hi All,
I'd like to read more case studies on PostGIS. I know some case studies are
listed in http://postgis.refractions.net/ .
Are there more case studies that you can refer me to?
Thanks in advance.
Mary
Hi,
I've two questions.
(1) I updated logging_collector = true in postgresql.conf because I want to
rotate the logs. I'd also like to set the log_min_message to 'debug5' so that
I can better debug the code for now and will change it back to a lower level
when it's in production. I'm looking at
Hi,
I'm running on Postgres 8.3.8. My system admin is ready to set up a cron job
for a daily database backup.
By reading the documentation over here:
http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I
only found the documentation for 8.3.10), and it looks like pg_dum
Hi,
I'm running on Postgres 8.3.8. My system admin is ready to set up a cron job
for a daily database backup.
By reading the documentation over here:
http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I
only found the documentation for 8.3.10), and it looks like pg_dum
Hi,
I'm looking at all the processes from 'ps' that are related to Postgres. How
come there is a process associated with a different date? Are those processes
to be expected? Should I be concerned? I'm running on Postgres 8.3.8. The
database is working and running.
Here is the list:
1 S
Hi,
I'm looking at my log file (see my log file below) and it seems like the
autovacuum daemon is turned on by default in Postgres 8.3.8. Does that mean
that I no longer need to manually invoke the autovacuum command anymore? I
used to do it manually in an older version of Postgres.
tail pos
...@gmail.com]
Sent: Wednesday, June 02, 2010 6:08 PM
To: pgsql-general@postgresql.org
Cc: Wang, Mary Y
Subject: Re: [GENERAL] Autovacuum Daemon is Turned On by Default in Postgres
8.3.8?
On Wednesday 02 June 2010 5:40:58 pm Wang, Mary Y wrote:
> Hi,
>
> I'm looking at my log file (s
Hi,
I've some test data in a database and would like to delete that database and
clean everything that is associated with that database. Then I'd like to
populate the same database with different data.
My plan is to:
(1) Remove the /usr/local/pgsql/data directory
(2) psql -e mydatabase -f /tmp/
to 8.3.8 anyway.
I assume most of you would just do the DROP DATABASE for the scenario that I
described. Is that correct?
Mary
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, June 03, 2010 4:10 PM
To: pgsql-general@postgresql.org
Cc: Wang
Hi,
I'm getting this error from postgres " ERROR: character 0x90 of encoding
"WIN1252" has no equivalent in "UTF8" " and from a dump file when I tried to
use psql command to restore the dump.
I have SET client_encoding = 'win1252' in the dump file.
Any ideas?
Thanks
Mary
--
Sent via p
uggestions?
Thanks
Mary
-Original Message-
From: Alban Hertroys [mailto:dal...@solfertje.student.utwente.nl]
Sent: Saturday, June 05, 2010 1:35 AM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ERROR: character 0x90 of encoding "WIN1252" has no
equiv
Hi,
I'm using a psql -f command to reload the data from a dump file. I noticed
that some tables are not populated with any rows (I mean 0 rows), yet, if I
manually insert a row (actually just copy an INSERT statement from that input
file) in the interactive terminal, that row was added with no
Sent: Monday, June 07, 2010 11:21 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Does psql -f quit insertion after an error in a
statement has been detected?
On Sun, Jun 6, 2010 at 5:29 PM, Wang, Mary Y wrote:
> I'm using a psql -f command to reload the data from a dump fil
Hi,
My internal customer has a new project and is considering using MySQL. Knowing
that I'm a Postgres person, the customer is open to considering Postgres at a
later date if the cost to transition is less than 40 hours. The database will
probably be relatively small and simple (still in the
Hi,
I'm trying to find some write-ups about the differences between Postgres and
MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and plan
to watch a recent webcast on PostgreSQL
Hi,
I'm having a problem right now. Some of our French users uploaded some files
with file names that had French accent marks, and those file names were
inserted into the Postgres database. When I examined the value of those file
names, they all had some weird characters (the weird characters
Hi All,
We are starting a new project in my organization and need to have a database.
I proposed that we use PostgreSQL. Because we already have the Oracle
infrastructure in-house, I'm told that I need to do a simple trade study on
Oracle vs. PostgreSQL. Based on the database requirements, i
Hi All,
I'd like to do a data dump of a table to a CSV or XML file.
How would I do that?
I'm running on Postgres 8.3.8.
Thanks in advance.
Mary Wang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpre
Hi,
Sorry for the double posting.
I'm having a bad day. My Postgresql has this error "FATAL 2: XLogFlush:
request is not satisfied". I tried to follow the instructions from a thread
about looking for a core dump, but when I tried to start the postmaster, I got
"/usr/bin/postmaster: Startup p
1 postgres postgres 16777216 Feb 1 10:51 000200F9
Thanks for any help.
Mary Y Wang
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Wang, Mary Y
Sent: Tues
Hi,
What is the graceful way to stop(kill) postmaster? I didn't use pg_ctl to
start so I won't use pg_ctl stop the postmaster. I used '/usr/bin/postmaster
-D /var/lib/pgsql/data -i&'. I was told not to use 'kill -9'.
Mary
Mary Y Wang
-
Hi,
I managed to restore my database. However, one table is not restored.
The error message that I was received was "copy: line 3057, Cannot insert a
duplicate key into unique index users_pkey..." and then "...PQendcopy:resetting
connection"
Then I went to the log file (my debug file was set to
?
Mary
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Wednesday, February 03, 2010 7:43 AM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PQendcopy:resetting connection Pro
ruary 03, 2010 2:21 PM
To: Scott Marlowe
Cc: Wang, Mary Y; pgsql-general@postgresql.org
Subject: Re: [GENERAL] PQendcopy:resetting connection Problem and Cannot insert
a duplicate key into unique index
Scott Marlowe writes:
> On Wed, Feb 3, 2010 at 2:16 PM, Wang, Mary Y wrote:
>> I
Hi,
I'm sorry but I didn't create the table. I fiddled with the table for a while
and didn't get what I expected. So I'm going to ask the community.
Can some one tell me which constraint would case me the "duplicate key into
unique index users_pkey"? I'd like to remove that constraint.
Here
Hi,
I restored my database. However, I noticed performance is poor as compared to
before.
Are there some easy things that I can do to improve the performance (besides
rewriting the code)?
My pgversion is 7.1.3 (I know, I know that I need to upgrade).
Thanks
Mary
--
Sent via pgsql-general
Hi PostgreSQL Community,
Are there any good PostgreSQL courses offered in the US Westcoast area? Would
be great if there is one in California.
Company's budget is tight. However, if the course is really great (need
recommendations from the community), travel any where in the US is OK too. I
@postgresql.org] On Behalf Of Rich Shepard
Sent: Thursday, February 04, 2010 8:52 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Any Good Postgresql Courses Offered in the US Area?
On Thu, 4 Feb 2010, Wang, Mary Y wrote:
> Are there any good PostgreSQL courses offered in the US Westco
Hi,
I have a table that have that duplicate rows. How do I find them and delete
them?
Please advise.
Mary
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
How do I drop a CONSTRAINT TRIGGER?
Thanks
Mary
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
Hmm. Things are still getting interesting around here.
Here is my complicated problem. I tried to delete a user from my users table,
but it said
"ERROR: bug_assigned_to_fk referential integrity violation - key in users
still referenced from bug"
Ok.
Then I saw this statement in the .sql f
not null default '0' |
Indices: bug_group_id,
bug_groupid_assignedto_statusid,
bug_groupid_statusid,
bug_pkey
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Wednesday, February 10, 2010 5:10 PM
7;A'
Indices: idx_users_username,
user_user,
users_user_pw
Someone mentioned about using 'alter table'. Would like would work? But I'm
not sure how to do it because \d doesn't show the constraint.
Any ideas?
Mary
-Original Message-
From
00
(3 rows)
What do I do with them?
Mary Y Wang
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, February 10, 2010 8:02 PM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How do I drop a Complicat
I guess I could just use
"DELETE FROM pg_trigger WHERE tgname = "RI_ConstraintTrigger_9217018"
I just wanted to make sure that I don't mess up the system table.
Mary
-Original Message-----
From: Wang, Mary Y
Sent: Wednesday, February 10, 2010 8:10 PM
To: 'To
Hi,
I'd like to allow all connections over TCP/IP networks. So could I just add
the following line to the pg_hba.conf in the $PGDATA directory?
"host all * trust"
The database server is located inside a firewall.
Thanks
Mary
--
Sent via pgsql-general mailing list (pgsql-genera
Hi,
I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in the
process of restoring the databases in Postgres 8.3.8. There were lots errors
showed on the screen when I ran this command 'psql -e template1 -f 21.bak' and
it actually displayed the line numbers where the errors occu
10 11:25 PM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to Output PSQL Errors to a Log File?
On Mon, 22 Feb 2010 23:19:34 -0800, "Wang, Mary Y"
wrote:
> Hi,
>
> I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in
t
I'm not clear when you said that "old pg_dump should work fine for this purpose
in practically all cases, so it's not worth your trouble to try to figure out a
workaround". Did you mean that it's OK to use the old version of pg_dump when
you are doing a major version upgrade when working with a
Cool! That worked. Thanks. Now I just have to see if I can migrate the
database data from 7.1 to 8.3 successfully.
Mary
-Original Message-
From: Devrim GÜNDÜZ [mailto:dev...@gunduz.org]
Sent: Monday, February 22, 2010 11:43 PM
To: Wang, Mary Y
Cc: Joshua D. Drake; pgsql-general
Hi,
I got this error:
"-bash-2.05b$ /usr/local/pgsql/bin/pg_ctl start
server starting
-bash-2.05b$ FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 7.3, which is
not compatible with this version 8.3.8."
I think I must have two
: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of A. Kretschmer
Sent: Thursday, February 25, 2010 11:04 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Two Versions of PostgreSQL Installed - How to uninstall
one particular version
In res
Hi All,
I'm in the processing of migrating to Postgres 8.3.8.
I did :
(1) initdb
(2) psql -e template1 -f 21.bak &>/tmp/out21.bak
Now, I've decided that I want to reload the same file again, do I just delete
the PGDATA directory and then
perform the same steps again?
(1) initdb
(2) psql -e tem
Hi All,
After a pg_dumpall, I'm trying to restore with psql -e template1 -f 21.bak
&>/tmp/out21.bak . I'm trying to migrate to Postgres 8.3.8.
I'm getting lots errors like this one:
"psql:21.bak:340557: ERROR: literal carriage return found in data
HINT: Use "\r" to represent carriage return.
ts of data. Now, I just
need to find out why some rows of some tables weren't able to be restored (I'm
sure they had some kind of errors). Happy Friday!
Mary
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Friday, March 05, 2010 5:36 AM
To: Richard Huxton
C
Hi All,
After a restore, I got a lot errors like this one : "duplicate key value
violates unique constraint "bug_pkey"". After looking at the dump file, it has
CREATE SEQUENCE bug_pk_seq
INCREMENT BY 1
MAXVALUE 2147483647
NO MINVALUE
CACHE 1;
ALTER TABLE
SELECT pg_catalog.setva
right now.
I've always suspected that the database was inconsistent state.
Thanks
Mary
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Saturday, March 06, 2010 8:06 AM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] What's the b
Hi All,
I got the following error and not sure how to fix it.
"psql:/tmp/030610dumpfile.txt:4369: ERROR: invalid byte sequence for encoding
"UTF8": 0x93
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encod
Hi Michal,
Thanks for the info. However, the text that the user entered is all in English
letters. I saw this error, when I restored my database with the pg_dump
--insert option. That row didn't get inserted to the table. What's
interesting about this problem is that when I manually entered
Thanks Alvaro. What do I do with a apostrophe (such as I've)?
Mary
Original Message-
From: Alvaro Herrera [mailto:alvhe...@commandprompt.com]
Sent: Friday, March 12, 2010 12:48 PM
To: Wang, Mary Y
Cc: Michał Pawlikowski; pgsql-general@postgresql.org
Subject: Re: [GENERAL]
Ok. What was I thinking, the "curved single quote" that you talked about is
the apostrophe. It makes sense now.
Thanks
Mary
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Wang, Mary Y
Sent: Friday, Marc
Hi,
I'm confused. I'm in the process of migrating to 8.3.8. I used pg_dump and
pg_restore command for migration.
Here is my problem.
Here is my old table prior migration:
\d activity_log
Table "activity_log"
Attribute | Type | Modifier
---+-
30, 2010 4:32 PM
To: pgsql-general@postgresql.org
Cc: Wang, Mary Y
Subject: Re: [GENERAL] Migration - not null default '0' -> not null default 0 -
confused
On Tuesday 30 March 2010 4:23:39 pm Wang, Mary Y wrote:
> Hi,
>
> I'm confused. I'm in the process of
Hi,
I'm trying to port some source code to Postgres 8.3.8 and have been
encountering some surprises :-(
I would like to set up a column constraint for an integer type, so that when
the value is undefined, it would assign a default value of 0 to that column.
How would I do that in 8.3.8? Please
Can someone provide a link to the Postgres 8.x documentation that provides
information about Null vs. Empty String?
Here is the situation:
Currently, the source code performs the following SQL statement :
UPDATE user_group set subversion_flags='' WHERE user_id='5818' AND
group_id='438';
(This SQ
-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Sunday, April 04, 2010 7:50 PM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Null vs. Empty String in Postgres 8.3.8
"Wang, Mary Y" writes:
> Can someone provide a link to the Postgres 8.x documenta
Title: Message
Hi,
I'm running
postgressql 7.1.3-2.
I've a
When I did a select
on the table, I was able to see that row. However, when I tried to update
that row, I got 'Update 0', I even tried to delete that row, I
couldn't. It seems like the database is confused. I did the Vacuum
a D. Drake [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 5:18 PM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to Update a Record
Wang, Mary Y wrote:
> Hi,
>
> I'm running postgressql 7.1.3-2.
> I've a
>
> When I did a select
Richard,
Thank you so MUCH. I was able to delete the record by using the OID
method that you mentioned in (2).
Thanks again.
Mary Wang
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Monday, August 01, 2005 9:44 AM
To: Wang, Mary Y
Cc: Joshua D. Drake; pgsql
]
Sent: Monday, August 01, 2005 11:08 PM
To: Wang, Mary Y
Cc: Joshua D. Drake; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to Update a Record
Wang, Mary Y wrote:
> Richard,
>
> Thank you so MUCH. I was able to delete the record by using the OID
> method that you mentioned i
Title: Message
Hi
All,
I have been using
PostgreSQL for my project repository, because it is free and easy to use.
My manager is trying to decide if he should use a commerical database such as
Oracle or PostgreSQL for a gaint information repository for the corporate.
He asked me what is
Title: Message
Hi
All,
I have been using
PostgreSQL for my project repository, because it is free and easy to use.
My manager is trying to decide if he should use a commercial database such as
Oracle or PostgreSQL for a giant information repository for the corporate.
He asked me what i
Hi,
Here is the table for bug:
Attribute | Type | Modifier
---+-+--
bug_id| integer | not null default nextval('bug_pk_seq'::text)
group_id | integer | not null default '0'
63 matches
Mail list logo
