Re: [ADMIN] How to restore updated records
Ivan, if you have configured WAL archiving, you may want to look at http://www.postgresql.org/docs/8.1/static/backup-online.html, especially paragraph '23.3.4. Timelines'. List: Maybe someone already hacked the postmaster to extract deleted records?! HTH, Oliver. -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von [EMAIL PROTECTED] Gesendet: Montag, 11. Juni 2007 19:35 An: pgsql-admin@postgresql.org Betreff: [ADMIN] How to restore updated records Hi all. Sorry for my problem. I am using pg on ~100 servers fro 5 y. without any problems, but this time I make a big mistake. A have a table tasks with about 2 records. The table have ID as pk and some other fields. I typed : update tasks set c1='sss'; instead update tasks setc1='sss' where id=10; And the pg updated all my table tasks. I do not have any backup on this table. Exists any way to restore the data> After the mistake I stopped to execute any commands to this database and also I DO NOT HAVE running vacuum, vacuum analyze ot vacuum full analyze on this table. I know pg stores the old copy of data, but I do not have any idea how to restore this deleted records. Pls., point me to any solution for this problem. Many thanks and best regards, ivan. - SCENA - Единственото БЕЗПЛАТНО списание за мобилни комуникации и технологии. http://www.bgscena.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[ADMIN] Postgresql - Windows platform
Hi, I installed postgresql in windows platform. I want to setup the server and client configuration on this. Kindly help me. (Server and client configuration). What are the configuration files I have to modify. Kindly reply ASAP. Waiting for your reply. Thanks & Regards Jayakumar M DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
Re: [ADMIN] Postgresql - Windows platform
--- Jayakumar_Mukundaraju <[EMAIL PROTECTED]> wrote: > I installed postgresql in windows platform. I want to setup the server > and client configuration on this. Kindly help me. (Server and client > configuration). What are the configuration files I have to modify. > Kindly reply ASAP. Waiting for your reply. This link is a good place to start. I can probably explain this process as well as I can. http://www.postgresql.org/docs/8.2/interactive/installation.html Regards, Richard Broersma Jr. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] How to restore updated records
No, I do not have WAL archiving. I hope some one have done the hacking in postmaster. If no one have done this, my idea was to change the vacuum (or make e new copy). I am not familiar with pg code, but as I know by running vacuum, pg marks deleted records as free, and my idea was to mark this records as real record in the database (if it is possible). regards, ivan. > Ivan, > > if you have configured WAL archiving, you may want to > look at > http://www.postgresql.org/docs/8.1/static/backup-online.html, > especially paragraph '23.3..4. Timelines'. > > List: Maybe someone already hacked the postmaster to > extract deleted records?! > > HTH, Oliver. > > -Ursprungliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von > [EMAIL PROTECTED] > Gesendet: Montag, 11. Juni 2007 19:35 > An: pgsql-admin@postgresql.org > Betreff: [ADMIN] How to restore updated records > > > > Hi all. > Sorry for my problem. > I am using pg on ~100 servers fro 5 y. without any > problems, > but this time I make a big mistake. > > A have a table tasks with about 2 records. > The table have ID as pk and some other fields. > > I typed : update tasks set c1='sss'; > instead update tasks setc1='sss' where id=10; > > And the pg updated all my table tasks. > > I do not have any backup on this table. > Exists any way to restore the data> > After the mistake I stopped to execute any commands to > this > database and also I DO NOT HAVE running vacuum, vacuum > analyze ot vacuum full analyze on this table. > > I know pg stores the old copy of data, but I do not have > any > idea how to restore this deleted records. > > Pls., point me to any solution for this problem. > > Many thanks and best regards, > ivan. > > - > > SCENA - Единственото БЕЗПЛАТНО списание за мобилни > комуникации и технологии. > http://www.bgscena.com/ > > > ---(end of > broadcast)--- > TIP 4: Have you searched our list archives? > >http://archives.postgresql.org > > ---(end of > broadcast)--- > TIP 7: You can help support the PostgreSQL project by > donating at > > http://www.postgresql.org/about/donate > > > - SCENA - Единственото БЕЗПЛАТНО списание за мобилни комуникации и технологии. http://www.bgscena.com/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[ADMIN] A question about memory usage
Hi all,
I have a server with 4GB of RAM and I wanted to know how much memory
is being used by a PostgreSQL. To do so I have executed the following:
ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 }
END { print "Real: ",rss/1024"MB Virtual: ",vsz/1024"MB" }'
And the result is:
Real: 157.59MB Virtual: 6359.04MB
So I understand that amount of virtual memory must be swapped to disk as
it's bigger that my physical memory. To check this I have executed the
free command and I get the following results:
total used free sharedbuffers cached
Mem: 4153180 3988536 164644 0 1614003117900
-/+ buffers/cache: 7092363443944
Swap: 6215672 646215608
So my question is, what I'm doing wrong? because the swap it's almost
empty
Thank you very much
--
Arnau
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Re: [ADMIN] A question about memory usage
>I have a server with 4GB of RAM and I wanted to know how much memory
> is being used by a PostgreSQL. To do so I have executed the following:
>ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 }
> END { print "Real: ",rss/1024"MB Virtual: ",vsz/1024"MB" }'
> And the result is:
>Real: 157.59MB Virtual: 6359.04MB
> So I understand that amount of virtual memory must be swapped to disk as
> it's bigger that my physical memory. To check this I have executed the
> free command and I get the following results:
> total used free sharedbuffers cached
> Mem: 4153180 3988536 164644 0 1614003117900
> -/+ buffers/cache: 7092363443944
> Swap: 6215672 646215608
>So my question is, what I'm doing wrong? because the swap it's almost
> empty
You are misunderstanding what these numbers mean on a UNIX system.
For starters -
http://virtualthreads.blogspot.com/2006/02/understanding-memory-usage-on-linux.html
And if you are not swapping, and your OS's cache is that huge, why
bother?
Use "ipcs" to display the allocation of shared memory.
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
[ADMIN] psql : Error: Cannot stat /pgdata/8.2/main
Hi, I have moved my database files from their default location to their own partition on with their own controller and disks. PostgreSQL works OK and I can connect with Pgadmin (Debian Lenny AMD64, PostgreSQL 8.2.4). When I want to connect with psql however (with a non-root account) I get the following: panoramix:~$ psql -d my_database Error: Cannot stat /pgdata/8.2/main /pgdata/8.2/main is the location where the database files are actually located. Why do I get this error and what should I do to be able to connect to the database? TIA -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
