Hi All,

I checked the file size of my database and it's 115GB. I already figured out
which tables suck up all the space and I decided to delete all the entries
in them. But still after emptying (DELETE FROM ), the file size
still hasn't changed. I already tried to VACUUM the table. Also, even if
there are already 0 records within the table that I emptied, when I query to
that table it's so slow and then it just gives a 0 results.

Is there anything that I missed out here? Like do I need to do some other
cleanups within postgres(eg. cache, etc)?

TIA for your replies. It would be very much appreciated.

Ridvan

--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos

I was beginning to create some financial functions for calculating
Future Values, PV's, etc -for basic retirement planning.
example:

CREATE OR REPLACE FUNCTION lotsa.FVPMT(payment double precision,
interestRate double precision, periods double precision)
RETURNS double precision AS
$BODY$
BEGIN
return payment*(pow(1+interestRate, periods)-1)/interestRate;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE

periods seems to be a problem. Usually, I'd be getting birth_date
from a file, but I'm not finding a way to
add 65 years - or 67 or whatever, to get the period between now (or an
assumed date) and retirement.

Dear all,

I am new to PostgreSQL and have just started using it for a few weeks.
I have a (probably very simple) question regarding an execution of a
SQL command which is automatically repeated every period of time. For
example, I want to copy a txt file into a table (e.g. with command
COPY traffic FROM 'C:/TEMP/flow.txt' ) every 5 minutes. The
'flow.txt' file is produced by an external system and updated (by
overwriting it) every 5 minutes. Can anyone let me know how to do it
or where to put the command in PostgreSQL to automate the execution of
the copy command according to time?
Many thanks in advance.

Yos

Is there a way wherein I can dump only the create statements (plus the
indexes and triggers) of a `specific` table without including the data? I
just need the dump of the table structure, indexes, and triggers.

Thanks in advance,

Ridvan

--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos

Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.

Is there a way wherein I can dump only the create statements (plus the indexes and triggers) of a `specific` table without including the data? I just need the dump of the table structure, indexes, and triggers.
Thanks in advance,Ridva

Hi all,

I need to specify servers and storage to run PostgreSQL. Does anyone
know any source of information (articles, presentations, books, etc.)
which describes methods of hardware sizing for running a large
PostgreSLQ installation?

Thank you in advance.

Sergio.

I'm planning on upgrading Ubuntu 7.10 to 8.04. Is there anything
special I need to do to preserve my Postgres 8.3 installation? Should
I backup the cluster and reinstall Postgres, or should I just do the
Ubuntu upgrade and expect Postgres to keep working?

Thanks for you advice,
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center

A total novice here!

Machine A: Kubuntu 8.04 has the required database under user userA
Machine B: RHEL 5 is the destination machine with userB

I want to transfer the entire database under userA from machine A to
user B under machine B. Is that possible?

--
Regards
PK
--------------------------------------
http://counter.li.org #402424

hello,

i have installed postgresql, and it's up and running fine, using the
postgres user account. however, when i run the pgadmin III utility,
and attempt to File>Open pg_hba.conf file, i cannot select it from
it's /data folder because it is obviously locked. i am using my
default os x user account, and so i clearly to not have access to that
postgres user folder. although i have a postgres user account, i do
not have a postgres user account listed under my Preferences >
Accounts. should i create one here? or is there any way to make the
existing postgres account visible in my Accounts list?

so, the question is; what would i need to do in order to make that
file easily selectable/editable using the pgadmin III utility

x user account?

i would prefer being able to use pgadmin to edit this file, instead of
having to use Terminal > sudo su > su -l postgres > vi/emacs
pg_hba.conf. also, i have not had much success in using vi or emacs
to edit the file, because it is read only, and i haven't been able to
figure out how to overcome that(i've shut down the postgresql server).

Hello:

I think I'm a little confused about the something in the documentation:

- I think table oids have been deprecated
(http://www.postgresql.org/docs/8.2/interactive/runtime-config-compatible.html)
- It looks like the only way to retrieve the comments associated with a
table is to use the function obj_descritption(object_oid, catalog_name).
(http://www.postgresql.org/docs/8.2/interactive/functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE)

Is this a different oid?

Thanks for the help!
Mija

I can't seem to find ecpg in my PostgreSQL installation yet the
libraries seem to be there in /usr/lib64. In the doc it says it should
be there in a typical install (which I believe mine is). whereis can't
find it either.

I'm on Suse 10.2.

I can’t seem to find ecpg in my PostgreSQL
installation yet the libraries seem to be there in /usr/lib64. In the doc it
says it should be there in a typical install (which I believe mine is).  whereis
can’t find it either.

 

I’m on Suse 10.2.