: Tom Lane <[EMAIL PROTECTED]>
To : "Duprez" <[EMAIL PROTECTED]>
Cc : pgsql-bugs@postgresql.org
Date : Thu, 10 Jul 2008 10:34:19 -0400
Subject : Re: [BUGS] BUG #4291: Inheritance fails on column
suppression
"Duprez" <[EMAIL PROTECTED]>
Dear Sur!
My name is Peter Kovacs and I work at the National Szechenyi Library in
Hunagry.
The reason why im writing this letter is the follow:
We are using Potgresql to store our data. We have UTF-8, LATIN1 and
LATIN2 encoded databases.
I haven't got any problem with database encoding before,
Hi,
My server is a postgres v7.1.3.
I have a database with OID and to backup my database i use this syntaxe :
pg_dump -Ft -b -o -f mydb.tar mydb
when i want restore my database i use this command line:
pg_restore -o -d mydb mydb.tar
and i have this error :
Archiver(db): Could not execute query. N
If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to [EMAIL PROTECTED]
To report any other bug, fill out the form below and e-mail it to
[EMAIL PROTECTED]
If you not only found the
sting/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
Hi,
before writing to this list I've tried to solve the problem
discussing it in the pgsql-performance mailing list but I wasn't able
to solve it.
The problem is as follows.
My test db only contains a
single table with some varying-text field and a bytea field.
When
inserting data into this t
>In psql the trick is to use unaligned display mode, else psql itself
>eats a whole lot of time trying to nicely format those 250KB rows:
Even using unaligned display mode (\a) it still takes more than 1
minute
>
>I surmise that your problem is likewise on the client side,
but you
>weren't ve
>Hmm ... what does VACUUM VERBOSE of that table show?
>
Here is the
output of VACUUM VERBOSE
INFO: vacuuming "public.FILE"
INFO: scanned
index "FILE_pkey" to remove 54 row versions
DETAIL: CPU 0.00s/0.00u
sec elapsed 0.01 sec.
INFO: "FILE": removed 54 row versions in 5 pages
DETAIL: CPU 0
>
>Well, that eliminates the theory that you've got a lot of dead
tuples
>slowing it down. I come back to the conclusion that it's
probably a
>client-side problem. Have you tried watching with "top" or
similar tool
>to check which process is eating all the time?
>
No,
actually I haven't yet
>
>No,
>actually I haven't yet.
>I have noticed that during the time
the query
>executes there is neither so much CPU load nor network
(communication
>with db) load. The client seems to hang, then after a
minute or so the
>query returns data.
>I also thought this problem
could be related to
Hello.
Can you help me? i don't know what to do with this message:
**
# pg_dump -U postgres catalog
Password:
pg_dump: query to obtain list of schemas failed: ERROR: more than one
row returned by a subq
hello
Help me please...
I have two "postgres" user. How to delete the first one ???
***
# select * from pg_shadow where usesysid=1;
usename | usesysid | usecreatedb | usesuper | usecatupd
| passwd| valuntil | useconfig
--+--+--
Hello?
help me plz? i don't khow what to do...
How can I delete first postgres user.
template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax from
pg_shadow where usesysid=1;
usename | passwd| valuntil | ctid | xmin
| xmax | cmin | cmax
--
Hello, help me please,
I don't know how, but i got 2 postgres users.
How can I delete the first one
thx alot for your answers.
Oleg
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Dear all,
I would like to know where can I get help or instructions about how to configure a database, for example size parameters etc.
Thanks,
C.Roberto Soares.
Goiânia - Brasil
Thanks!
Bruce Spear
[EMAIL PROTECTED]
mail2web - Check your email from the web at
http://mail2web.com/ .
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi,
I manage several databases PostgreSQL 7.3.1 and I have noticed a problem.
When I delete many rows (with OID) the free space of disk doesn't changed !
I make a vacuumdb, but I doesn't notice an increase of the free space disk.
In a last step, I make a backup and a restoration but, it's the same
://mail2web.com/ .
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
puis Voila ! www.voila.fr
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
io Mazzoni
Macron Srl
http://eteampoint.com
# SOME DESCRIPTIVE TITLE.
# FIRST AUTHOR <[EMAIL PROTECTED]>, YEAR.
#
msgid ""
msgstr ""
"Project-Id-Version: PostgreSQL v7.4\n"
"POT-Creation-Date: 2003-10-05 13:26-0300\n"
"PO-Revision-Date: 2003-10-08 19:10
Hello all..
I have a 7.4.2 pg server and the situation is the following:
Table detorders with 69 columns, one of which is called docomment. There is a view
based on this table called qrydorders and there are other 5 views which include
qrydorders in there definitions. Today after changing (with
Dear Postgres!
Sorry my bad English first.
I'm found a bug in the PSQL 8 Beta2 Devel 3, and 7.4.x (x=2,3,4,5) too:
- The PSQL 8 is working on Win XP.
- The PSQL 7.4.x is working on SuSE and Yoper Linux distros.
I have 8900 users is in 4 group.
1. I'm maked a 'pg_dumpall -c >full_dump.sql'
2. I make
Dear Developer Team!
I use the PostgreSQL 7.4.5 on SLES9.0 and PostgreSQL 7.4.3 on SuSE 9.0
(I think this problem exists in 8.0 too).
If you make 'create user' and 'alter group' sql command on existing
users, and make it many times, the server doesn't release the memory.
After 6-7000 calls the s
Logged by: Lutischan Ferenc
Email address: yoursoft ( at ) freemail ( dot ) hu
PostgreSQL version: 7.4.3, 7.4.5
Operating system: Linux: SuSE9.0, SLES9
Description:Out of memory
Details:
Dear Developer Team!
I use the PostgreSQL 7.4.5 on SLES9.0 and PostgreSQL 7.4.3 on SuS
centre of
Kola Science Centre of
Russian Academy of
Science
mailto:[EMAIL PROTECTED]
PS
sorry my english...
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go
pgsql-bugs,
when i install src pg ,must mkdir data1 frist,then,
./bin/initdb -D ./data can be successful,why?
[EMAIL PROTECTED]
2005-06-30
Tom Lane wrote:
"fischer" <[EMAIL PROTECTED]> writes:
c99 -O3 -mips4 -woff 1164,1171,1185,1195,1552 -I. -I../../../src/include
-I/usr/local/include -I/usr/local2/include -I/usr/nekoware/include
-U_NO_XOPEN4 -c -o analyze.o analyze.c
Signal: Segmentation
Is it possible to do an online backup from linux to windows ?
Postgres : 8.1.0
linux : Centos 4.2 , 32 bit
windows : 2000 Server , 32 bit
When I try to start recovery process on windows I'm getting the following error:
FATAL: incorrect checksum in control file
thank you
-
28 matches
Mail list logo