I recommend you look at chapter 5, "Data Types", of the PostgreSQL
User's Guide.
[EMAIL PROTECTED] wrote:
Hello ALL.
Where can I find (and set if need) all defined max length restrictions of PostgreSQL
server.
for example,
max lenght of VARCHAR,
or any variable-length array,
or max query len
Hi,
recently we are suffering from repeated
WARNING: Rel pg_toast_77798203: Uninitialized page 25489 - fixing
entries in the logfile.
We had this problem 2 weeks ago (especially on some read often write often
tables), along with some more severe problems (pg_clog not found etc..). We
assumed h
But I have blobs in my data so I am using -F c
At 01:22 PM 6/5/2003 -0700, Jonathan Gardner wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 June 2003 04:56, David A. Leedom wrote:
> I am using 7.2.x. When I run pg_dump on a database the objects are not
> loaded in the correct
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 June 2003 03:49, Stephen J. Thompson wrote:
> Hello all,
>
> I am trying to restore a 7.3 database with many schemas and schema users in
> it. The issue I am having is that there are many \connect statements in the
> backup file and it k
unsubscribe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 June 2003 04:56, David A. Leedom wrote:
> I am using 7.2.x. When I run pg_dump on a database the objects are not
> loaded in the correct dependency order.
>
> S when I run pg_restore it fails because objects that are needed
> hav
IIRC correctly this happened in 7.3, though I believe libpqxx is
backward compatible,
Robert Treat
On Wed, 2003-06-04 at 01:51, Anagha Joshi wrote:
> Hi,
> Pls. let me know immediately from which version of Postgres ...
> C++ interfaces are moved to the libpqxx PostgreSQL Projects.
> Libpqxx is
On Thu, 2003-06-05 at 04:54, Peter Childs wrote:
> On Wed, 4 Jun 2003, Shankar K wrote:
>
> > hi all,
> >
> > I'm trying to evaluate the frequecy to run vacuum
> > analyze on key tables. so if anyone could help me to
> > interpret the output of vacuum analyze verbose output
> > that would be gre
I did an vacuum full on a particular table of
pgsql 7.2.3 database as a non superuser.
and i feel i have lost considerable data in this
text feild in this table. I think it was a known bug with
this version.
btw there was a # sign in the prompt does it
not mean the connected user was a super use
Dave-
I ran into this recently & made a similar inquiry of the list. Apparently
the pg_restore dependency problems are known issues, but not fixed in 7.2. I
haven't looked to see if it is fixed in 7.3 yet.
In our case, space was not an issue and backups run quickly enough that I
just do two backu
All,
My CEO has asked for a PostgreSQL White Paper
to give to a Client.Before I start typing - anyone
have one or can point me to one ?
Many thanks ( and thanks for the info this group provides ),
Terry Hampton
Does PostgreSQL have a tool to diagnose and fix database corruption? Is
there any kind of database consistency checker? I couldn't find anything in
the doc...
Thanks!
Alex Pollock
WFSC Data Services District
Database Administration
MAC A0186-032
( 415) 243-5931
---(en
On Tue, 2003-05-27 at 09:26, Nathalie Boulos wrote:
> Hello everyone,
>
> I was able to open postgresql tables on linux from MS-access on windows
> using the ODBC found on postgresql.org website.
>
> I was wondering if there is a way that a postgres database on linux sees and
> modifies access
On Thu, Jun 05, 2003 at 10:12:25AM -0400, Vinay wrote:
> figured that it is because I have to do the init db everytime this
I don't know anything about the Cyg Win installation, but you _don't_
need to do initdb every time: that creates a new data area.
A
Andrew Sullivan
On Thu, Jun 05, 2003 at 01:41:27AM -0700, Marvin wrote:
> When I issue the command ./configure when installing
> POSTGRESQL I encounter the error
> "configure: error: No acceptable C compiler found in
> PATH "
> Can someone advice me on what to do with this error.
Sounds like you don't have a C
You should not have to run initdb after each restart, check out the
following link on setting up cygwin as a service:
http://www.tishler.net/jason/software/postgresql/postgresql-7.3.2.README
future questions should be posted to pgsql-cygwin
Robert Treat
On Thu, 2003-06-05 at 10:27, Vinay wrote:
Hi-
I'm posting this summary for a person that I've been corresponding with
off-list:
He is trying to use JDBC, so he wants to turn on the TCP/IP socket.
The platform is Postgresql 7.2 on SuSe 8.0
If he starts the postmaster with the -i flag, he can get a connection.
If he sets tcpip_socket =
[EMAIL PROTECTED] writes:
> Is it normal that when we do a vacuumdb, the number of open files
> decrease ?
Doesn't surprise me --- that'd be a likely result of the relcache
flushes that vacuum will trigger.
regards, tom lane
---(end of broadcast)--
Hi-
I'm posting this summary for a person that I've been corresponding with
off-list:
He is trying to use JDBC, so he wants to turn on the TCP/IP socket.
The platform is Postgresql 7.2 on SuSe 8.0
If he starts the postmaster with the -i flag, he can get a connection.
If he sets tcpip_socket =
Tom,
Thanks for the advice. I realize your concern, but it turns out there was a
simple solution. I'd like to share that solution with the list, since the
solution I received was not posted on the list. Since "VDS" servers are
becoming more popular by the day, this might be useful to some other a
this is a repost, first one didn't pass moderator ?!
---
Hi,
recently we are suffering from repeated
WARNING: Rel pg_toast_77798203: Uninitialized page 25489 - fixing
entries in the logfile.
We had this problem 2 weeks ago (especially on some read often write often
tables, which are often va
On Fri, 2003-06-06 at 09:42, Kris Kiger wrote:
> I'm looking for a good way to monitor disk I/O on a linux
> system. Specifically, I would like to know when postgres is making
> page-ins and page-outs. If anyone knows of a good utility, please let
> me know! Thank you for the help
vmstat.
-
> When I issue the command ./configure when installing
> POSTGRESQL I encounter the error
> "configure: error: No acceptable C compiler found in
> PATH "
> Can someone advice me on what to do with this error.
... I had this problem on Solaris... I can't remember which cc it
found first in my pa
<[EMAIL PROTECTED]> writes:
> I did an vacuum full on a particular table of
> pgsql 7.2.3 database as a non superuser.
> and i feel i have lost considerable data in this
> text feild in this table. I think it was a known bug with
> this version.
The vacuum output shows 91902 live tuples during th
Hello.
We had a very serious trouble last week with our databases in Postgres and we
wanna know if maybe someone can help us to find the problem.
The trouble was that a day some databases in Postgres appear without any row
of information; some other, doesn't led us describe the tables (\d),
"Jonathan Gardner" <[EMAIL PROTECTED]> wrote:
> This is also a cheap way to "vacuum" the database:
>
> # pg_dump | gzip > dump.gz
> # dropdb
> # createdb
> # gunzip -c dump.gz > psql
Yes specially when you have a dump of about 1 GB and
you manage a service 24/24 7/7!!
The only cheap way to v
I have error when restoring file DUMPall PG7.1.3 to
PG7.3.2
with error message "function varchar(integer) does not
exist"
any one can help ?
thanks before it
===
"TELKOMNet Instan memberikan diskon 40% unt
Hello.
We had a very serious trouble last week with our databases in Postgres and we
wanna know if maybe someone can help us to find the problem.
The trouble was that a day some databases in Postgres appear without any row
of information; some other, doesn't led us describe the tables (\d), o
28 matches
Mail list logo
