Re: [GENERAL] Transaction wraparound vacuum synchronicity

bad, that, because it seems to me that this is a use case where one might want to put a thumb on the scale, and having to twiddle a parameter just to affect one table is kind of user-unfriendly.) A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8

always make this mistake at least once per installation, even after many years.) A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8

On Wed, Mar 09, 2011 at 10:31:56AM -0500, Tom Lane wrote: Andrew Sullivan a...@crankycanuck.ca writes: On Wed, Mar 09, 2011 at 03:58:20PM +0200, Sandy Test wrote: Unfortunately, even with the pg_hba.conf fix of adding host postgres ... trust, If it is asking for a password, and password

Re: [GENERAL] updating all records of a table

in between groups, so that the table doesn't get too bloated. Otherwise, yeah, you're better off to do some of the cleanup Joshua suggested. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Unprivileged access to pgsql functions?

: select nvl(0,1); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Is the function in your search_path? A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Index question

? A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Lock ACCESS EXCLUSIVE and Select question !

seat number. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Lock ACCESS EXCLUSIVE and Select question !

are in READ COMMITTED or SERIALIZABLE isolation mode, respectively. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Full Vacuum/Reindex vs autovacuum

this only so as not to disrupt your regular operations; otherwise, I'd suggest going back to autovacuum and seeing whether reindex alone would help you. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Lock ACCESS EXCLUSIVE and Select question !

not understanding database trasactions. It's almost certainly the wrong thing. If you said more about what you're trying to do, maybe someone can help you. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Lock ACCESS EXCLUSIVE and Select question !

at the same time). In the latter case, you have to try a new seat. Hope that helps, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Lock ACCESS EXCLUSIVE and Select question !

you're feeling. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Lock ACCESS EXCLUSIVE and Select question !

something if you don't have the list of inventory prior to its being sold. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PG on two nodes with shared disk ocfs2 drbd

On Sun, Feb 27, 2011 at 01:48:24PM +0100, Jasmin Dizdarevic wrote: A drbd disk in dual primary mode with ocfs2-filesystem. Will there be any conflicts if using the shared volume as PGDATA directory? Yes. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list

Re: [GENERAL] PG on two nodes with shared disk ocfs2 drbd

it to work most of the time. I know at least one metronet deployment that didn't work even once for two years.) In the case of the MySQL stuff, there are some trade-offs in the design that make my heart sink. But maybe for the OP's application it will work. A -- Andrew Sullivan

Re: [GENERAL] PG on two nodes with shared disk ocfs2 drbd

, but barring magic I don't think it'll happen soon. Multi-master transactional ACID-type databases with multiple masters is very hard. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] PG on two nodes with shared disk ocfs2 drbd

-suited to this sort of thing, despite the overhead that it imposes. This is a matter of trade-offs, and you might want to think about different roles for different boxes -- especially since hardware is so cheap these days. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general

Re: [GENERAL] Adding a column with constraint

exactly what everything does. I haven't checked just this instant, but I think you can rename the constraint if you don't like its name. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Worst case scenario of a compromised non super-user PostgreSQL user account

to have two accounts: one owns the objects, and another that has INSERT/DELETE/UPDATE and so on permissions. If the application is creating tables, you might want to ask yourself why. Other than that, what others said. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general

Re: [GENERAL] disable triggers using psql

. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] disable triggers using psql

into all tables BEFORE any constraints are created. I believe that if you did a data-only dump from pg_dump you would have the same integrity problems. Yes. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Raid Controller Write Cache setting for WAL and Data

run into a problem. A battery is one of the simplest and cheapest things you can do to make your database system more reliable and faster at the same time. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Question about switchover with PG9 replication

, no. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to create index on only some of the rows

for inclusion in the index? Those would be the criteria you put in your WHERE clause. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Adding more space, and a vacuum question.

table? It's managed by postgres, but given your churn rate on these tables I'd be tempted to set a fillfactor with a lot of room, and let the tables be big (i.e. with a lot of empty space) so that their long term storage footprint is stable. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via

Re: [GENERAL] Re: Separating the ro directory of the DB engine itself from the rw data areas . . .

variable. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Installing Postgres with MS SQL Server 2005

that they're contending for resources, and that neither one of them is especially co-operative when they're starved of the resource they want. But otherwise, I can't think of any reason it would. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

replacing everything that comes after it, so such an attack would be easier to detect. Not an impossible attack, just harder.) A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

is a bad fit for that. Use SQLite or one of the other things that target embedded use. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] help understanding collation order

. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] array_agg-like thing over arrays

, arrayofstuff text[]); SELECT item_id, array_agg(arrayofstuff) from eg1 WHERE class_id = 1; But this, of course, gives an ERROR: could not find array type for data type text[]. What am I missing, or have I just misremembered that this was ever possible? Thanks, A -- Andrew Sullivan

Re: [GENERAL] array_agg-like thing over arrays

On Sat, Jan 15, 2011 at 01:35:20AM +0300, Dmitriy Igrishin wrote: Try SELECT item_id, array_agg(arrayofstuff::text) from eg1 WHERE class_id = 1; Doh! That's it. Thanks! A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Case Sensitivity

insensitive collation. For instance, I can assure you that customers named Leblanc and LeBlanc care about whether those two compare equally. In your customer name field, if you have a database-wide collation setting, you can't make the distinction. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via

Re: [GENERAL] UUID column as pimrary key?

and analysis. It's exactly the kind of of analysis that professional paranoids like DBAs are for. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] UUID column as pimrary key?

of other risks lurking around that also need erro checking. I fully agree with this. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] UUID column as pimrary key?

. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] UUID column as pimrary key?

pay any of us for. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] query stuck at SOCK_wait_for_ready function call

/interactive/view-pg-locks.html). By the way, the advice you got yesterday about upgrading is good advice. I wouldn't keep running the version you're running. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Restore problem

editor, isn't it? A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Any way to use refcursors from python?

completely overlooked something (there would be no news in that, of course)? Is there some other interface I ought to be using? Thanks, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Any way to use refcursors from python?

, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Vacuums taking forever :(

differently? I think the cron jobs are your problem. These cron jobs are taking over 35 minutes for a vacuum! What's the use of a vacuum if it takes that long, and the DB performance is tragic in the meantime? VACUUM uses disk bandwidth. I suspect you are causing part of your problem. A -- Andrew

Re: [GENERAL] Pet Peeves?

On Thu, Jan 29, 2009 at 09:51:42AM -0800, Joshua D. Drake wrote: It should be pg_backup and that is it, with a nice -R flag for restore. I suppose you think that ssh_add -D is an intuitive interface too? ;-) A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list

Re: [GENERAL] Slow Vacuum was: vacuum output question

with their program. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Data Replication

useful to me. -- Andrew Sullivan [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] shared disk failover

On Sun, Dec 07, 2008 at 02:36:56PM -0500, Jaime Casanova wrote: Hi, any one has doing this... is there a good tutorial o directions for it? The answer to this is highly dependent on the system you're using. What is it? A -- Andrew Sullivan [EMAIL PROTECTED] -- Sent via pgsql-general

Re: [GENERAL] two postgres server seeing the same data

. This will permanently corrupt the data. I know this partly because of experience with a failover system whose interlocks failed. Two postmasters, one data area, and no recoverable data. A -- Andrew Sullivan [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] two postgres server seeing the same data

On Wed, Dec 03, 2008 at 04:23:15PM -0500, Jaime Casanova wrote: is this true even if one of the server just send SELECTs? Yep. A -- Andrew Sullivan [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Monty on MySQL 5.1: Oops, we did it again

, that. A -- Andrew Sullivan [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] slow, long-running 'commit prepared'

concurrency--only a couple of open sessions--when the COMMIT PREPARED is issued. You could be I/O bound. Have a look at iostat and sar. A -- Andrew Sullivan [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] slow, long-running 'commit prepared'

you have to save a whole lot of state. And when you then do COMMIT PREPARED, you say, Lose that state in favour of this new state. All that work has to be done again, in the other direction. It's not for nothing that people think 2PC is a heavyweight and expensive system. :-( A -- Andrew

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

granularity. Indeed, it seems to me that in some ways, the big databases are only catching up with Postgres now on this front. That alone oughta be news :) -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Archiving WAL for 7.4.21

On Tue, Oct 28, 2008 at 02:25:05PM +0400, Mohd Alkhaldi wrote: I've postgres 7.4.21 , is there is any way to archive WAL , I've tried No. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Import db from 8.1.3 to 8.3.1

it without going all over again and remain with 8.3.1 database where I have already put alot of important data. Why don't you use the latest 8.3.x release? You don't need a dump and restore to go from 8.3.1 to 8.3.latest. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http

Re: [GENERAL] Import db from 8.1.3 to 8.3.1

On Thu, Oct 23, 2008 at 08:24:12PM +0300, Otandeka Simon Peter wrote: Upgraded to 8.3.4 but am still getting the same error So it isn't an error in 8.3.1. But my bet is this: On Thu, Oct 23, 2008 at 4:35 PM, Andrew Sullivan [EMAIL PROTECTED] wrote I am trying to import db from 8.1.3

On standards weenies (was: [GENERAL] Annoying Reply-To)

the ß character (LATIN SMALL LETTER SHARP S) should or should not be allowed into internationalized domain names. -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Annoying Reply-To

were standardized many years ago. Then you reply to list. Mutt has done this for at least a few years now. I don't know about other MUAs. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Annoying Reply-To

and in the potential for lost functionality. Given the project's goal of SQL conformance, why would we blow off SMTP standards? (Anyway, I agree with Tom, so I'm saying nothing more in this thread.) A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com

Re: [GENERAL] 8.4 RPMs

. Please note that these are _not_ for production use, and almost certainly have bugs. They may not be the very latest, either. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Re: Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?

On Mon, Sep 29, 2008 at 06:41:33AM -0700, [EMAIL PROTECTED] wrote: On 16 sep, 23:04, [EMAIL PROTECTED] (Andrew Sullivan) wrote: Specify the specific TCP/IP interfaces in the postmaster.conf file. I have the same pb. I have looked for a postmaster.conf file but there Doh! Sorry, that should

Re: [GENERAL] Oracle and Postgresql

, but let's at least be honest that changing the culture of such database shops is not something we're going to achieve quickly.) A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: Obfuscated stored procedures (was Re: [GENERAL] Oracle and Postgresql)

On Thu, Sep 25, 2008 at 01:25:25PM -0700, Casey Allen Shobe wrote: Gee, I wonder why companies that support these antics grow to insane sizes of employees? Meetings. Lots and lots of meetings. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com

Re: Obfuscated stored procedures (was Re: [GENERAL] Oracle and Postgresql)

also enough, in my opinion, but obviously others disagree.) A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] Slony vs Longiste

On Tue, Sep 23, 2008 at 03:36:51PM -0500, Jason Long wrote: From what I read Longiste is easy to set up while I got a quote for Slony setup for 5-10k. I can set up Slony for way less than that, FWIW. But Londiste is intended to be easier to set up than Slony. A -- Andrew Sullivan [EMAIL

Re: Obfuscated stored procedures (was Re: [GENERAL] Oracle and Postgresql)

be worth implementing. So far, I don't believe anyone's had an itch of this sort strong enough to scratch. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?

. Otherwise, Postgres will try to bind to all the sockets. There's something hinkey about the IPv6 support in AIX, IIRC, so that you end up with this symptom. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] PostgreSQL TPC-H test result?

On Tue, Sep 09, 2008 at 05:42:50PM -0400, Greg Smith wrote: While some of the MonetDB bashing in this thread was unwarranted, What bashing? I didn't see any bashing of them. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql

Re: [GENERAL] PostgreSQL TPC-H test result?

a year old, at that). I didn't get any further in reading the claims, because it's obviously nothing more than a marketing effort using the principle that deriding everyone else will make them look better. Whether they have a good product is another question entirely. A -- Andrew Sullivan [EMAIL

Re: [GENERAL] PostgreSQL TPC-H test result?

the claim is true that way. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL process architecture question.

is not automatically necessary to get more than one processor to work on a single query. But at the moment, Postgres doesn't do that either. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] PostgreSQL TPC-H test result?

several years to turn itself into a full-featured, high-volume, safe transactional system. But the seams keep showing, because it just wasn't designed for this workload in the first place. But it sure is fast out of the box on a single-user system! A -- Andrew Sullivan [EMAIL PROTECTED] +1 503

Re: [GENERAL] Dumping/Restoring with constraints?

relevant here, but give it a whack. Other than that, I'm not sure. You might want to troll the release notes to see if there was an encoding bug fixed in the intermediate releases between 8.2.whatever-you-converted-on and 8.2.current. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104

Re: [GENERAL] Dumping/Restoring with constraints?

, and whether in these versions that is captured in the dump file. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Dumping/Restoring with constraints?

[other stuff] A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Slow PG after upgrade to 8.2.9!!

to come off the disk. Does iostat seem to confirm that? Are you swapping, by any chance? A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Vaccuum best practice: cronjob or autovaccuum?

gave you this feeling? What's the churn rate on these tables (i.e. how fast do dead rows get created?) My suspicion is that, using the 8.2 autovacuum, your huge table needs to be vacuumed manually, and the others just left to autovacuum. But that's just a guess at the moment. A -- Andrew

Re: [GENERAL] Vaccuum best practice: cronjob or autovaccuum?

of the vacuums it's working when I see the weekly drop of disk ocupation. It actually bloats your index and hurts you. Don't do that. If the number of tuples in your various tables is staying about the same, your size on disk should stabilise. That's the thing you want to see. A -- Andrew Sullivan [EMAIL

Re: [GENERAL] Dumping/Restoring with constraints?

. What's the database encoding? A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Dumping/Restoring with constraints?

On Wed, Aug 27, 2008 at 10:40:41PM +0800, Phoenix Kiula wrote: Thanks. But there seems to be a tangible slowdown of DB operations during the time that pg_dump is running. Yes. Pg_dump copies all the data out, so it puts load on your database and disks. A -- Andrew Sullivan [EMAIL PROTECTED

Re: [GENERAL] Dumping/Restoring with constraints?

initdb on one system with a locale of C and on another with a locale of utf-8 (somehow). You can use pg_controldata to find out: run it against the data areas on each system. If I'm right, then you probably want to run initidb again on the target system. A -- Andrew Sullivan [EMAIL PROTECTED

Re: [GENERAL] Dumping/Restoring with constraints?

. This is not a trivial job, however. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

experience trying it. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

again. You do need to run pg_dump -s, of course. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [Q] DNS(bind) ER model

to find that some users can't resolve your names in the near future.) A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] [Q] DNS(bind) ER model

idea. I think it's now 5 years since the DNS folks pointed out that TXT was going to cause headaches later. Sigh.) A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] [Q] DNS(bind) ER model

. Bert is hostile to it.) A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [Q] DNS(bind) ER model

it wouldn't be that hard to get information about the wire datatypes such that you'd have enough information to implement them in Postgres (assuming you know something about Postgres datatypes). One hint: remember the unknown RRTYPE. If you have questions about RRTYPEs, I'm happy to answer. A -- Andrew

Re: [GENERAL] Postgres eats all memory

don't even show any evidence here that Postgres is using the memory. How do you know that? A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] replication only

with a cluster and Slony versus Skytools) is my recommendation. This is probably good advice. For simple cases, Slony's sort of a pain in the neck. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Re: should i need to install xml library in postgresql inorder to work on xml file?

be in a separate package on Debian. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] php + postgresql

code in any language.) A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Problems with pg_dump and -t wildcards

that. The ability to specify multiple -t switches came in 8.2. You can work around this if you have a custom dump format, by just restoring the tables you want using pg_restore. This is a pretty hideous workaround, though. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http

Re: [GENERAL] replication

connections through an ssh tunnel that's using compression. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] Correct pg_dumpall Syntax

/data, and then use pg_dumpall against that backend. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Correct pg_dumpall Syntax

a non-ascii dump format? Try psql -U postgres -f pg814data.sql A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Overloading

On Fri, Jun 13, 2008 at 06:11:43PM -0700, Ralph Smith wrote: I get: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. Don't use CREATE OR REPLACE for the second one. The OR REPLACE is trying to replace a function of the same name. A -- Andrew Sullivan

Re: [GENERAL] Heavily fragmented table and index data in 8.0.3

traded them for a lump of pig iron, they were so flakey. Having Sun on the outside in no way protects you from faulty hardware. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] does postgresql works on distributed systems?

storage? the answer is, No. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgresql MVCC, Read Committed Isolation Level and taking snapshot

). That means _before_ you call the first function (since calling the function is then the first statement in the transaction, before serializable). A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Postgresql MVCC, Read Committed Isolation Level and taking snapshot

* tables. This is more than one statement. So you will be able to see changes in between those statements. If you don't care about that, then your approach will work. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing

<    1   2   3   4   5   6   7   8   >