---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
If you must use inserts, you'll get much better performance if you
wrap the restore in a transaction. I think someone came up with a
clever way to do this on the command line, or you could edit the dump
file. Note that if you do this and there's any errors, the restore
will fail.
Also, gr
On Aug 8, 2006, at 7:19 AM, mcelroy, tim wrote:
Thank you Thomas. I've tried it but get a few syntax errors. I
have postgresql 8.0.1 installed and have moved it to /var/lib/pgsql
to mimic Linux so I need to edit the file some more. I'll let you
know how it works.
You need to upgrade. You'
On Aug 8, 2006, at 3:10 AM, Sharma;G.S. wrote:
Dear all,
I have a database of 53GB , i want to know break up of these 53GB .
Is there any command or way through which i can find out that how
much space is used by database,Transaction Log,TempDB, tables
indexes etc.
The sysviews project on h
On Aug 7, 2006, at 10:36 PM, Geoff Parker wrote:
Unfortunately I didn't notice the problem until I saw the logs
today, and by then it was back tor normal.
Is it safe to assume this is abnormal behaviour?
Probably, unless you had a transaction running for 2 days that was
using space in pgsq
On Aug 6, 2006, at 9:47 AM, Srinivas Iyyer wrote:
I have two databases in my system.
In firstdb i am having the following problem:
firstdb=# \d targets
ERROR: could not access status of transaction 362
DETAIL: could not open file
"/var/lib/pgsql/data/pg_clog/": No such file or
director
On Aug 2, 2006, at 11:34 AM, Scott Marlowe wrote:
Postgres v7.4.2 (upgrade underway)
If you can get a clean backup, look into at least 8.0. There were
huge
improvements from 7.4 to 8.0. 8.1 is even more impressive. (says
the DBA
who's still running 7.4.13 on all his boxes... :)
Most im
On Aug 7, 2006, at 9:08 PM, Benjamin Krajmalnik wrote:
I have a database whose records are inserted via ODBC.
I turned on logging, and the client is explicitly setting the
client encoding to UTF.
Rows are inserted into the tables. When I do a pg_dump, I do not
get any errors. When I try t
First, you need to upgrade to 8.1.4.
You can redirect STDOUT to /dev/null. Error messages will be sent to
STDERR.
On Aug 7, 2006, at 9:00 AM, Nicola Mauri wrote:
I scheduled a dump between two databases, via network:
pg_dump --clean -U postgres mydb | psql -q -h remote_host -d mydb -
U po
On Aug 6, 2006, at 6:42 PM, Geoff Parker wrote:
Hi,
I've got a database with about 155GB of binary data, however when I
run the unix utility df, it reports only 60GB of disk space is
being used. I've extracted random samples of data from the
database, and it all appears correct, so I pres
On Mon, 2006-08-07 at 09:00, Nicola Mauri wrote:
> I scheduled a dump between two databases, via network:
>
> pg_dump --clean -U postgres mydb | psql -q -h remote_host -d mydb -U
> postgres
>
> I'd like to have no output being generated, unless an error condition
> occurs, so that crond will em
On Saturday 05 August 2006 21:07, jesus martinez wrote:
> hello, how are you ?
>
> i want to distribute a copy of PostGres to my clients.
> they really dont know anything about installing
> programs or
> configurating remote RDBMS sql-servers,
> so i dont want to give them the
> "official-PostGres-
When I try to install silently on windows xp the error message is
Internal account lookup failure. No mapping between account names and
security IDs was done.
I have deleted existing accounts and rebooted the os before.
I have read a workaround would be creating the users manually. This is a
pr
On 8/7/06, Nicola Mauri <[EMAIL PROTECTED]> wrote:
I scheduled a dump between two databases,
via network:
pg_dump --clean -U postgres mydb |
psql -q -h remote_host -d mydb -U postgres
I'd like to have no output being generated,
unless an error condition occurs, so that crond will email me only
On 8/7/06, Benjamin Krajmalnik <[EMAIL PROTECTED]> wrote:
I have a database whose records are inserted via
ODBC.
I turned on logging, and the client is explicitly setting
the client encoding to UTF.
Rows are inserted into the tables. When I do a
pg_dump, I do not get any errors. When I
Hi,
Postgres 7.3
Is there any way to know the size taken up by each
table and indexes in postgres .
I am having a 53 GB database which contains tables
, indexes, functions etc , how i can distribute these 53 GB's in database
objects .
Thanks in advance
Disclaimer :- This e-mail message
Hi,
I am using Postgres 7.3
can any body tell me is there any Tempdb in
postgres, like it is in Oracle or SQL Server ?
If it is there in postgres pls tell me how i can
see the space used by tempdb while my application is running ? I have a
database of 53 GB ., also can i configure the
size o
Hi,
When I run an online-backup script(v810) on SLES, the process immediately
goes into the 'D' STATE.
The backup finishes in a couple of hours. The backup is good and I can
restore. Why does it do that though? If I run the backup script at 12:20
AM instead of 1:20 AM it finishes in 20 m
Title: RE: [ADMIN] Start-up script for Solaris
Thank you Thomas. I've tried it but get a few syntax errors. I have postgresql 8.0.1 installed and have moved it to /var/lib/pgsql to mimic Linux so I need to edit the file some more. I'll let you know how it works.
Thanks,
Tim
-Origin
Am Dienstag, 8. August 2006 13:27 schrieb mcelroy, tim:
> Good morning,
>
> Curious if anyone out there has a start-up script for Solaris? A
> version of the Linux /etc/init.d/postgresql one. I recently installed
> postgres on a Solaris 9 box and although I can start up postgres it
> fails to log
Title: Start-up script for Solaris
Good morning,
Curious if anyone out there has a start-up script for Solaris? A version of the Linux /etc/init.d/postgresql one. I recently installed postgres on a Solaris 9 box and although I can start up postgres it fails to log to the log file as directe
2006. August 04. Friday 19.47 dátummal RPK ezt írta:
> I modified one of the .CONF files located in the Postgresql\Data
> Folder. I just changed the amout of shared_Buffer from 1000 to 100
> and Max_Connections from 100 to 2.
>
> But after that the PGSQL service stopped working. It stopped
> listen
> I just finished running some benchmarks on an underpowered server
> compared to the one I am running in production.
> My initial tests were run on an ampty database, pg_xlog on the same
> spindle.
> Stored procedure execution speed was ~15 ms.
>
> I then restored the production database so I wo
Dear all,
I have a database of 53GB , i want to
know break up of these 53GB .
Is there any command or way through which i can
find out that how much space is used by database,Transaction Log,TempDB, tables
indexes etc.
Thanks in Advance
Disclaimer :- This e-mail message including any
24 matches
Mail list logo
