Thanks Richard Huxton for your reply.
I use client side api for uploading and downloading files.
Its not happening immediately. But when database grows with data, file
object got corrupted.
My table structure is as follows.
Table "public.conf"
Column | Type | Modif
Scott Marlowe schrieb:
Andreas wrote:
now this might be a bit of a silly question, but I'll give it a shot
anyway.
I'm working on a remote database for a few employees of a rather
small startup company where at least a few will get teleworking jobs.
They'll get a ms-access application that c
Purusothaman A wrote:
Thanks Richard Huxton for your reply.
I use client side api for uploading and downloading files.
Its not happening immediately. But when database grows with data, file
object got corrupted.
Yes, but *HOW* - is it a different file, length is different, what?
My table st
check that you don't have any of the previous version's binaries in your
path
From: "Islam Hegazy" <[EMAIL PROTECTED]>
To:
Subject: [ADMIN] initializing the DB cluster
Date: Tue, 22 May 2007 23:45:18 -0600
Hi all
I installed the source of PostgreSQL 8.2.3 on a linux machine. The
i can't find out command to show all databases,tables,users and
integrity constraints relationships;
yours sincerely
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your jo
On Wed, May 23, 2007 at 10:44:36AM +0200, Andreas wrote:
> The problem - not only - of my customer is that he primarily has to
> trust strange people enough to grant them access to the very base of his
> business and this base could be carried away on an USB stick or piped
> out via email or wha
use tables/views in scheme pg_catalog/information_schema
try
select * from pg_catalog.pg_database;
select * from pg_catalog.pg_user;
select * from pg_catalog.pg_tables;
Mondi Ravi schrieb:
i can't find out command to show all databases,tables,users and
integrity constraints relationships;
you
Hi!
Just for other users who might have the same question:
With default settings, postgres writes 3 WAL files. Each of them has
the size of 16 mb. They are located at the data directory within the
subdirectory pg_xlog.
Cheers,
Peter
Am 22.05.2007 um 21:22 schrieb Peter Elmers:
Hi Chri
Mondi Ravi napisał(a):
i can't find out command to show all databases,tables,users and
integrity constraints relationships;
yours sincerely
See tables and views of system catalogs:
http://www.postgresql.org/docs/8.2/interactive/catalogs.html
and use just SELECT statements on them to get what
On May 23, 2007, at 4:44 AM, Andreas wrote:
Right.
It's like that. They should work on projects that only contain a
subset e.g. of customer addresses and subsequently on the task
related objects like orders regarding the current project.
Another thought is to make all data returned throug
"Islam Hegazy" <[EMAIL PROTECTED]> writes:
> I installed the source of PostgreSQL 8.2.3 on a linux machine. The =
> installation process ended successfully but when I try to create the =
> database cluster using the initdb command I get the following error:
> "
> creating conversi
On 5/23/07, John DeSoi <[EMAIL PROTECTED]> wrote:
On May 23, 2007, at 4:44 AM, Andreas wrote:
> Right.
> It's like that. They should work on projects that only contain a
> subset e.g. of customer addresses and subsequently on the task
> related objects like orders regarding the current project
Hi there,
I want to write a script where I can create a database
automatically. This is intended to create a database during the
installation of an application I'm currently develloping. So, I (or
the end-user of my app) can't be prompted for the postgres password
during the app installation.
I a
Ok, we are looking more into this. In the mean time, can someone please
explain to me (or point me to the correct documentation) what happens in
PostgreSQL when a commit is issued. What exactly does the database do?
Thanks,
Chris
On 5/22/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Chris H
Chris Hoover escribió:
> Ok, we are looking more into this. In the mean time, can someone please
> explain to me (or point me to the correct documentation) what happens in
> PostgreSQL when a commit is issued. What exactly does the database do?
It writes a commit WAL record and flushes (fsync) t
Hi there,
I want to write a script where I can create a database automatically. This
is intended to create a database during the installation of an application
I'm currently develloping. So, I (or the end-user of my app) can't be
prompted for the postgres password during the app installation.
I already found that it's possible to store passwords in the file pgpass.conf
in the %APPDATA% directory. But that file isn't stored in that location. In
fact it doesn't exist in my disk. I already checked the "Store password"
Filipe,
You need to create that file yourself. Using the format
Dear Richard Huxton,
Thanks for your quick reply.
only the first 3 values(HX, MASK, Rockey4ND) are file object's oid value.
the other two are are not oid values.
I have shown original output values displayed by postgresql client.
I can explain more.
1. HX is a XML file. after downloading that
Purusothaman A wrote:
Dear Richard Huxton,
Thanks for your quick reply.
only the first 3 values(HX, MASK, Rockey4ND) are file object's oid value.
the other two are are not oid values.
Umm - OK. Can I suggest perhaps having different tables for different
types of data?
I have shown origina
How to monitor PgSQL performance, like JConsole for Java Virtual Machine?
Usage of memory, CPU, etc.
Thank you,
Jair.
Richard Huxton,
Thanks for your detailed reply.
I am maintaining various database of same kind in postgresql.
Here I have shown various corrupted last line of output of select * from
pg_largeobject where oid = xx; in 5 databases.
I have used '\o e:\\filename.xml' before executing query and
I already had done this but it seems the "Store password" function stores
the password in a file other than the pgpass.conf because it really stores
passwords with or without that file.
Can anyone tell me if it is possible to set the "Store password" option in a
file? Because if it isn't possi
If you are using windows, it's under "%APPDATA%\postgresql\pgpass.conf"
(where %APPDATA% refers to the Application Data subdirectory in the windows
user's profile and not the postgres user.
From: "filipe paiva" <[EMAIL PROTECTED]>
To: pgsql-admin@postgresql.org
CC: [EMAIL PROTECTED]
Subject:
Apart from select statements you can use the following commands on psql
prompt -
\d [NAME] describe table, index, sequence, or view
\d{t|i|s|v|S} [PATTERN] (add "+" for more detail)
list tables/indexes/sequences/views/system tables
\da [PATTERN] list aggregate functions
Purusothaman A wrote:
Richard Huxton,
Thanks for your detailed reply.
I am maintaining various database of same kind in postgresql.
Here I have shown various corrupted last line of output of select * from
pg_largeobject where oid = xx; in 5 databases.
I have used '\o e:\\filename.xml' befo
25 matches
Mail list logo
