Hi Everbody,
I'm running Red Hat Linux Enterprise 2.1.
I am currently running pg 7.3.2 and want to come up to 7.4.1.
I don't need to backup the existing DB and I'd prefer to remove 7.3.2 and install 7.4.1 clean.
However, I see that there is only a rhel3 package available, and when trying
Bruno,,
Perfect, exactly what I was looking for. It's is also available in
version 7.3.x which I use.
RTFM , I would say :-[
Thanks,
Willem
Bruno Wolff III wrote:
On Mon, Jan 12, 2004 at 22:06:01 +0100,
ListSrv <[EMAIL PROTECTED]> wrote:
Hi,
Is it possible to query de backend database
I know that there are standard ways to graph relational databases.
It occured to me that perhaps programs existed which simply parsed the
table definitions and plotted the graphs for you.
Anyone know of such a thing?
Thanks.
-Tony
---(end of broadcast)--
Hi folks,
Guess this has been hashed b4.. But I would like to know if PITR is
supported yet? If no, can you pls advice in which version will support for
same will be added?
Thx
Deep
---(end of broadcast)---
TIP 9: the planner will ignore your desir
On Mon, Jan 12, 2004 at 22:06:01 +0100,
ListSrv <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it possible to query de backend database for retrieving rights of an
> user in a group for a
> table?
In 7.4 there is a group of functions that seem to do what you want.
The functions are listed in table 9
Hi,
Is it possible to query de backend database for retrieving rights of an
user in a group for a
table?
I know that the userrights can be retrieved as:
SELECT relacl FROM pg_class WHERE relname = '[table name]'
and the users-id in groups as:
SELECT grolist from pg_group where groname = 'grou
Dear Jan Wieck ,
Yes I agree with you Jan , most of the time we round the amount and
this is done by truncating greater than 3 decimal digits and
rounding the 3 digit to 2 in other words :
select trunc(1000.236897,3);
then
selecr round(1000.236,2);
This takes care of the rounding factor in m
Dear Jan Wieck ,
Floating point math itself is not precise, but rather an approximation,
usually of 8 or 14 digits. You can't approximate money. This isn't a
PostgreSQL issue but rather a general programming issue.
Thanks, Bruce. I assume the arbitrary precision arithmetic Jan
mentioned which
On 1/12/04 11:17 AM, Sai Hertz And Control Systems wrote:
> Dear Alexey Bobkov ,
>> Then a try to restore my data:
>> pg_restore /path_to_database/backup/db_backup.file
>> and get next error
>> pg_restore: [archiver] input file does not appear to be a valid archive
>
> Use psql instead with comman
Dear Alexey Bobkov ,
Then a try to restore my data:
pg_restore /path_to_database/backup/db_backup.file
and get next error
pg_restore: [archiver] input file does not appear to be a valid archive
Use psql instead with command
psql -U username databasename -f yourdb_file.sql
Yes you will have to edi
On Mon, Jan 12, 2004 at 13:14:20 +1100,
Russell Shaw <[EMAIL PROTECTED]> wrote:
> Hi,
> I just installed pgsql on debian. Can i have initdb create
> the database cluster in my home directory and have it all
> owned by russell instead of postgres?
This should work. You will need to run the postma
Tom Lane wrote:
Alexey Bobkov <[EMAIL PROTECTED]> writes:
I have been dumping my database with next options:
pg_dump -f /path_to_database/backup/db_backup.file -Z 9 database_name
and get db_backup.file file.
This is giving you a plain SQL-script dump file. To restore, feed it
into psql.
No :)
Alexey Bobkov <[EMAIL PROTECTED]> writes:
> I have been dumping my database with next options:
> pg_dump -f /path_to_database/backup/db_backup.file -Z 9 database_name
> and get db_backup.file file.
This is giving you a plain SQL-script dump file. To restore, feed it
into psql.
PostgreSQL 7.3.2
I have been dumping my database with next options:
pg_dump -f /path_to_database/backup/db_backup.file -Z 9 database_name
and get db_backup.file file.
Then a try to restore my data:
pg_restore /path_to_database/backup/db_backup.file
and get next error
pg_restore: [archiver] input f
14 matches
Mail list logo
