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 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:
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,
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
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
: 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 mary.y.w...@boeing.com wrote:
I'm using a psql -f command to reload the data from
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
...@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
equivalent in UTF8
On 5 Jun 2010, at 4:44, Wang, Mary Y wrote:
Hi,
I'm getting this error from postgres ERROR
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
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
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, Mary Y
Subject: Re
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
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
...@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 (see my log file below
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
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
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
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
[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 mary.y.w...@boeing.com writes:
Can someone provide a link to the Postgres 8.x documentation
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?
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
: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 migrating to 8.3.8. I used
pg_dump and pg_restore
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
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] ERROR
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, March 12, 2010 12
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
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 best way to deal
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
Cc: Wang, Mary Y
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
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.
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
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
-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 response to Wang, Mary Y :
Hi,
I got this error:
-bash-2.05b
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
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
: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
mary.y.w...@boeing.com
wrote:
Hi,
I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in
the
process
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
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
,
bug_groupid_statusid,
bug_pkey
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Wednesday, February 10, 2010 5:10 PM
To: pgsql-general@postgresql.org
Cc: Wang, Mary Y
Subject: Re: [GENERAL] How do I drop a Complicated Constraint Trigger After
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, February 10, 2010 6:30 PM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How do I drop a Complicated Constraint Trigger After
Delete Execute Procedure?
Wang, Mary Y mary.y.w...@boeing.com
?
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 Complicated Constraint Trigger After
Delete
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: 'Tom Lane'
Cc: pgsql-general
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,
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
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
] 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 Westcoast area?
Would
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
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 Problem and Cannot insert
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 scott.marl...@gmail.com writes:
On Wed, Feb 3, 2010 at 2:16 PM, Wang, Mary Y mary.y.w
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,
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
: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: Tuesday, February 02, 2010 9:56 AM
To: pgsql
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
]
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 in (2).
Well
]
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 on the table, I was able to see that row.
However,
when I tried
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
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,
60 matches
Mail list logo