On Wed, Aug 24, 2005 at 07:43:57PM -0400, Napolean wrote:
>
> I am performing evaluation of Postgres 8.0 Database.
As long as you're doing an evaluation, consider also evaluating the
upcoming 8.1 beta. Watch for the announcement within the next few
days.
> Is there a way to recover all the data
All:
I am performing evaluation of Postgres 8.0 Database.
Is there a way to recover all the data from "Data" folder, if at all
anything happens.
Could any of you point me in the right direction is appreciated.
thanks
Napolean
---(end of broadcast)
Ivan <[EMAIL PROTECTED]> writes:
> As you can see, disk usage stop grows for several hours
> (3-5) after vacuum, then start again.
You don't have max_fsm_pages set large enough. Note the output at the
end of the VACUUM printout:
> INFO: free space map: 67 relations, 20713 pages stored; 29872 to
I think the best you could do would be to estimate it based on index key
size and knowing the overhead for the index structure. Note that it
probably wouldn't be too hard to codify this; it's just that no one has
done it.
http://www.postgresql.org/docs/8.0/interactive/storage.html would be a
good
You should also take a look at
http://pgfoundry.org/projects/newsysviews/; it makes getting this kind
of info out of the database much easier.
On Wed, Aug 24, 2005 at 02:43:31PM +0530, Gnanavel S wrote:
> run the psql command with -E option and do
> \d tablename.
>
> On 8/24/05, sandhya <[EMAIL
> ПОДРОБНО: 414193 dead row versions cannot be removed yet.
Increase max_fsm_pages in postgresql.conf.
Ivan wrote:
Hello,
OS: Windows 2003 Server SP1
DB: Postgresql-8.0.3
I have a database for caching html pages. Main table consists of
fields for URL (varchar(8192)), page body (text) and a f
Hello,
OS: Windows 2003 Server SP1
DB: Postgresql-8.0.3
I have a database for caching html pages. Main table consists of
fields for URL (varchar(8192)), page body (text) and a few others.
Pages has various expiration time (up to 3 days). Every 30 minutes
a special program deletes expired pages fr
Hi,
Thanks for your reply,
I have noticed that the file that contains pg_class table has been
disappeared. I don't know how.
Anyway, I have restored from my backup.
Thanks again.
Erol
- Original Message -
From: "Aldor" <[EMAIL PROTECTED]>
To: "Erol Oz" <[EMAIL PROTECTED]>
Cc:
Sent: W
One of the environments we are using PostgreSQL 8.0 in is Windows 2003,
single-disk, non-logging environment.
- Can somebody comment on the advantages of using / not using pg_default vs.
a separate tablespace for non-template databases, outside of the ability to
control separation tables and index
I don't understand the error message in detail but my opinion is that
there is something really broken - so I would backup your databases,
initialize the pgdata with initdb again and then restore it.
Maybe somebody else understands/knows what the error means.
Erol Oz wrote:
Hi,
I get,
ERROR:
I don't think this is possible...
you could try a explain on the create
index command but... this is like playinng lotto, didn't try it and
don't have the time to try it;-)
i think getting the size is only possible after creating the index,
because when the index is created it will gather the
Ok I understand but I need to know the size of the index before i create it
I need to know how much space it will ocupy (before actually create
the index, having the information of the table on wich I will build
the index), is this possible?
thanks in advance to everyone that can help me.
On 8/23
Hi,
I get,
ERROR: _mdfd_getrelnfd: cannot open relation
pg_class: No such file or directory
message.
Is there anything I can do, or should I drop
database and restore it from backup?
Thanks in advance.
Erol
run the psql command with -E option and do
\d tablename.On 8/24/05, sandhya <[EMAIL PROTECTED]> wrote:
Hi,
Is there any equivalent command for '\d
tablename'.
Inorder to get the table structure is there any SQL
query in postgres?
Thank you,
Regards,
sandhya
-- with regards,S.GnanavelSa
On 8/24/05, Sivakumar K <[EMAIL PROTECTED]> wrote:
Oliver,How should I use this?I tried this way but of no use.psql -E -U siva -d template1 -c \d test (test is a table in template1)
add the missing quotes
psql -E -U siva -d template1 -c "\d test"
Am I missing anything here?Regards,Siva Kumar.K---
Oops sorry for that post.
Actually we need to do like this.
Psql -E -U siva -d template1
Template1=>\d test;
It gives the queries.
Thanks
Siva Kumar.K
-Original Message-
From: Oliver Elphick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 24, 2005 2:47 PM
To: sandhya
Cc: postgre; Siva
Oliver,
How should I use this?
I tried this way but of no use.
psql -E -U siva -d template1 -c \d test (test is a table in template1)
Am I missing anything here?
Regards,
Siva Kumar.K
-Original Message-
From: Oliver Elphick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 24, 2005
On Wed, 2005-08-24 at 11:50 +0530, sandhya wrote:
> Hi,
> Is there any equivalent command for '\d tablename'.
> Inorder to get the table structure is there any SQL query in postgres?
>
use psql -E to see the SQL commands that are used to implement \d and
other such commands.
--
Oliver Elphick
Hi,
Is there any equivalent command for '\d
tablename'.
Inorder to get the table structure is there any SQL
query in postgres?
Thank you,
Regards,
sandhya
19 matches
Mail list logo
