Re: [ADMIN] Something like pg_dump for 7.4

catching them one by one, and getting also help with iconv as Tom mentioned, you should be able to fix that - good luck! -- --- Artur Pietruk, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropri

Re: [ADMIN] PostgreSQL internals and implementation of transactions

l be enough for me, and I will keep finding and reading docs. thanks! -- --- Artur Pietruk, [EMAIL PROTECTED] On Fri, Dec 17, 2004 at 11:07:42PM +0100, Artur Pietruk wrote: > Hi, > > I'm happy user of PostgreSQL for some years. I'm intrested to > conf

[ADMIN] PostgreSQL internals and implementation of transactions

rters of postgres! I like and admire the PostgreSQL's way of doing things in a clean "the right" way, according to standards, keeping in mind future expand of PGSQL features and so on. Best regards, -- --- Artur Pietruk, [EMAIL PROTECTED] ---(end of broadca

Re: [ADMIN] problem: Postgresql and Unicode

e meta tag? Make sure, that data you want to insert, is in fact unicode. I'm just wild-guessing, I have never created unicode DB in postgres, but I was fighting with enocding issues here and there. Best regards, -- --- Artur Pietruk, [EMAIL PROTECTED] ---(en

Re: [ADMIN] sequence

On Wed, Jan 08, 2003 at 05:08:35PM -0800, Roberto Benitez wrote: > I have a field of serial type. for some reason, the > sequence skips numbers every now and then. does anyone > know why? Canceled/rollbacked transactions? BR, -- --- Artur Pietruk, [EMAIL

Re: [ADMIN] dumping a password-protected db from a perl script or a binary

? Here psql should connect to db 'test' as user 'test', password 'test'. Check if it works with pg_dump. I hope that helps! BTW - there are also other ways to do that... Check docs of your pg version. $PGPASSWORD is deprecated. Best

Re: [ADMIN] createuser --password

switch of psql, eg like this: psql -c "ALTER USER test WITH PASSWORD 'test';" template1 Best regards, -- --- Artur Pietruk, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [ADMIN] vaccumdb vacuum memory usage

Is there memory leaks in this command. > Is it possible to clear the memory cache for postgresql Hi, How do you measure, that there is memory leak? Could you post here example commands with results, so others could look at it? What OS? Best regards, -- --- Artur Pietruk

Re: [ADMIN] sort order

C_CTYPE=iso_8859_2. It works at one of my systems. Regards, --- Artur Pietruk, [EMAIL PROTECTED] --- IBM RS6000/AIX System Administrator, WebMaster @ PDi, SQL/C++ programmer --- Amiga User: Amiga 4000 PowerPC 604 233MHz

Re: [ADMIN] sort order

cale support enabled :). --- Artur Pietruk, [EMAIL PROTECTED] --- IBM RS6000/AIX System Administrator, WebMaster @ PDi, SQL/C++ programmer --- Amiga User: Amiga 4000 PowerPC 604 233MHz

Re: [ADMIN] X-ReplyTo: owner-pgsql-admin@postgreSQL.org

lled it from rpm, so config files should be in /var/lib/pgsql directory. --- Artur Pietruk, [EMAIL PROTECTED]

Re: [ADMIN] problems with ecpg, postgres6.4.2 on linux

> I think ' { IN | FROM } ' means that you must type IN or FROM Yes, thats correct... in my book it is [ in | from ]... Thank's again! --- Artur Pietruk, [EMAIL PROTECTED]

Re: [ADMIN] problems with ecpg, postgres6.4.2 on linux

orks with 'exec sql fetch FROM...' too... My SQL book says that 'FROM' is optional (and it was optional in pgsql6.3, when i switch to 6.4 it didn't work). Is it ecpg bug, or error in my sql-book? --- Artur Pietruk, [EMAIL PROTECTED]

[ADMIN] problems with ecpg, postgres6.4.2 on linux

Best regards, --- Artur Pietruk, [EMAIL PROTECTED]