Is there a way to query the DDL comments for tables or databases?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
The following query works from Psql's prompt but not from Psql's "-c"
command or from PHP's PDO interface.
SELECT description FROM pg_catalog.pg_description WHERE description
SIMILAR TO '\d+' ORDER BY description::integer DESC LIMIT 1;
The result should be the description with the highest int
Good afternoon everyone,
I am setting up Postgresql on my redhat 8 system. I
have installed the files and have set up the proper
directories, however I have run into a problem. I am
trying to initialize the database with initdb. The
command is
pg$ /usr/local/pgsql/bin/initdb -D
/usr/local/pgsql/d
On Sun, May 30, 2004 at 10:45:02PM -0700, Uwe C. Schroeder wrote:
> On Sunday 30 May 2004 09:44 pm, Paul Gimpelj wrote:
> > If I connect to any database with psql I can see all the other databases in
> > table pg_database under postgresql 7.2
> >
> > What happens if I delete all the rows from this
Hi,
I am working on a RHEL 5 box where I do not have any administrative
access. But if need be, I can request the administrator to do some
changes. Currently the following packages are installed on the box:
postgresql.i386, postgresql-contrib.i386, postgresql-devel.i386,
postgresql-docs.i386, po
Thanks Tom,
On Mon, Jun 23, 2008 at 7:53 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "P Kapat" <[EMAIL PROTECTED]> writes:
>> If I understand correctly, the shared libraries for postgis should be
>> inside $PKGLIBDIR for the server to see them. Is there any u
On Mon, Jun 23, 2008 at 11:03 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> Frankly, there's going to be zero interest in any proposal to make this
> more flexible, because making it more flexible means opening a
> truck-sized security hole. We don't *want* Postgres loading code from
> random places
i had a similar (though not as complicated) question:
On Fri, Apr 10, 2009 at 5:34 AM, Kevin Bailey
wrote:
> We're trying to get a script to backup and restore a whole database server.
>
> So far we're looking at something like
>
> for db in `psql -U postgres -At -c 'select datname from pg_databa
Is there any way to resume an incomplete Pg-restore from a custom Pgdump file?
When loading from a custom Pg-dump it'd be helpful to have the option to resume
an incomplete or failed attempt. Is there any way to do this now?
Is there any way to process WAL logs of an OLTP database for use in a writable,
index heavy, OLAP database? Are there projects out there doing something
similar with the WAL logs?
So far all I've found is Xlogdump and Pglesslog
--
Sent via pgsql-admi
Is there a default timeout setting for connections to
the database?
TIA.
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
---(end of broadcast)---
TIP 2:
I need to increase the default max connection setting
from 32 to over 500. What other parameters should I
consider when adjusting this setting?
TIA.
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
-
Is there a default timeout setting for connections to
the database?
TIA.
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
---(end of broadcast)---
TIP 4:
Will someone please provide or point out where current
instructions are located for building and installing
the database? The instructions at www.postgresql.org
do not discuss the additional tar files
(postgresql-opt-7.3.2.tar.gz,
postgresql-test-7.3.2.tar.gz,
postgresql-base-7.3.2.tar.gz,
postgre
Will someone please provide or point out where current
instructions are located for building and installing
the database? The instructions at www.postgresql.org
do not discuss the additional tar files
(postgresql-opt-7.3.2.tar.gz,
postgresql-test-7.3.2.tar.gz,
postgresql-base-7.3.2.tar.gz,
postgre
What is the graceful way to disconnect other users
from a database? Is there a command that I can use
within psql or is it simply "kill $PID_OF_USER" from
the OS shell?
Thanks.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
---
Is anyone else having problems searching the archives
at archives.postgresql.org? It searches for a bit and
returns:
Search Time: 10.375 Search results: disconnect : 0 /
0, other : 0 / 0, users : 50 / 50 Displaying
Documents: 0-0
The problem is that is does not display any results,
i.e. no link
What is the graceful way to disconnect other users
from a database without shutting it down? Is there a
command that I can use within psql or is it simply
"kill $PID_OF_USER" from the OS shell command line?
Thanks.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.
I am trying to find the differences between 7.3.2 and
7.3.3. Where is the link containing this information?
Thanks.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
---(end of broadcast)---
Hi!
I use:
- PostgreSQL 6.5.3 on i386-FreeBSD3.4;
- clients on Win98-WinNT;
- ODBC driver version 6.40.0009.
In the end of session client calls SQLDisconnect, SQLFreeConnect, SQLFreeEnv.
And I get message from the server:
> pq_recvbuf: unexpected EOF on client connection
In manual I read:
"The
approve vYyvLS unsubscribe pgsql-admin [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I have postgres installed both in a Debian Sarge and in a Slackare 10.2
systems.
When I connect to a database via psql and do a select * from table; I
get the first page of results, considering \pset pager is on.
In Debian, I can press the key
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| I have the same issue too. I can only use the space bar to go down the
| results, page up and down keys do not work and neither does the end key.
Thank you Bruce! I lost any hope that I'd get any answer in this
newsgroup, so I posted the same qu
Hello.
Just interesting, anyone from this list ever try Postgres-R for
cluster/replication?
Sorry for OT.
--
Anton P. Linevich
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs
here id='103164'
LOG: duration: 5181.864 ms statement: update videos set watched=watched+1,
last_view_date='1166057434' where id='112060'
LOG: duration: 38394.879 ms statement: update upload_synchronizer set
lock_status='N' where sess_id=&
hi
i have a backup of pgsql in .tar format
how can i make the database unzipped from that
jim
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that yo
hi all ,
i want to retrieve records from my java program
i am getting these exceptions
pls help me
No class found for refcursor
at org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1C
onnection.java:693)
at org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(Ab
Command to import data from text file to postgresql table
1. Create table of the same order os text file. Then execute the command at
Query analyser.
copy tablename from textname (with path) CSV
eg: copy friends.office1 from 'C:/FRIENDS/ksebsouth.txt' CSV
regards
Beena
- Original Message
Command to import data from text file to postgresql table
1. Create table of the same order os text file. Then execute the command at
Query analyser.
copy tablename from textname (with path) CSV
eg: copy friends.office1 from 'C:/FRIENDS/ksebsouth.txt' CSV
regards
Beena
- Original Messag
x27;t seem to find a way to pass a CTRL-D character from within a bash
script to the postgres executable.
Has anyone done anything like this? Any suggestions? I am running
postgres 3.1.1.8 on Solaris 5.10.
Thanks!
John
John P Weatherman
Sr DBA
Asurion, Inc.
--
Sent via pgsql-admin mailing
It would also be helpful to know what your LD_LIBRARY_PATH looks like
and if you can do a 'find / -name libpq.so -print' to see where all the
copies of this library may reside.
On Thu, 2009-09-17 at 12:16 -0600, Scott Marlowe wrote:
> On Thu, Sep 17, 2009 at 12:06 PM, u235sentinel wrote:
> > No
system usage is low and rerunning seems to let it go through,
which would suggest to me this is a miss leading error at best. The
"transaction" doesn't really seem to be the problem. This is happening
on as CREATE AS SELECT.
Thanks,
John P Weatherman
Sr DBA
Asurion, Inc.
--
links to pull the
real time data...keeping them away from production with ad hoc code.
I'm not sure if there is any way to do that with postgres.
Thanks,
John
John P Weatherman
Sr DBA
Centerstone
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
in my own sqlfu in the catalog tables. Does anyone have a
script for identifying tables without indexes that correspond to their
PKs? I'm just trying to avoid re-inventing the wheel if I can help it.
Thanks,
John
John P Weatherman
Sr Database Administrator
Centerstone
--
Sent via pgsql-adm
Awesome! Thanks Bob.
On Tue, 2011-04-19 at 12:51 -0700, Bob Lunney wrote:
>
> Slony will use any unique index on a table for replication purposes, so the
> list of tables should come from:
>
> select relname
> from pg_class c
> join pg_namespace n on c.relnamespace = n.oid
> where nspname
Due to Hard disk space issue on the WAL partition, database was down , When I
am going to start postgres again ,got following error message
This DB is grater than 1 TB restore will take long time , any other way
other than pg_resetxlog ?
Nov 14 04:32:41 dbname postgres[4384]: [2-1] 2011-11-14
ctive) need strict checking?
Any way we could do that, without bringing down the DB (i.e. anything
besides a PGDump)?
Thanks
Manoj K P
PG Version:
==
mydb=# SELECT version () ;
ve
No, all my index B-Tree Index
Thanks
Manoj K P
2011/12/18 杨晓青
> is your index a hash index? xlog does not include the changes on hash
> index,your must rebuild hash index after recovery from xlog.
>
>
> 2011/12/16 K P Manoj
>
>> Hi
>>
>> The details give
Hi
Could any one else give any pointers, or is there something obviously
missing in this request / thread ?. Index "IND_tbl_1_ObjId" and
"IND_tbl_1_Act_ObjId" are B-Tree Index.
Thanks
Manoj
2011/12/19 K P Manoj
> No, all my index B-Tree Index
>
> Thanks
>
Hai,
I have problem in PostgreSql Multidimensional Arrays, which
I need to use in my project.I need to fetch a particular value or one
dimensional array from a two dimensional array or from a multidimensional
array without specifying the dimensions or index. Please help me out to
Hi ,
You are mentioned SHMMAX larger value is no harm for the database , can i
keep this value as 100% of RAM ?
Right now we have two cluster in this server , one is having 8 GB and other
2 GB shared buffer .
But i am facing some issue , OS cache is filled frequently once i run some
query o
I've been using Gmail and thought you might like to try it out. Here's an
invitation to create an account.
You're Invited to Gmail!
K P Manoj has invited you to open a Gmail account.
Gmail is Google's free email service, built on the idea that email can be
intuitive
Hello, All!
Resently I had to create and manage the (relatively) large table.
In the mean time it's about 8 million rows, and surely will grow above
this size.
The problem is that queries takes absolutely not acceptable time.
Database located on average Celeron 400 machine with 128 Mb of RAM and
Thanks a lot!
Although I wasn't clear enough in my questions I got pretty informative
answers.
Now I see, that I need faster hardware or to rethink the whole problem,
which is somewhat cheaper and much more interesting.
Thanks again for your answers.
Nicholay
---(end
Hello, All!
Today I tried the following query on a large table (11543179 rows).
SELECT sum(raw_bytes)
FROM raw_acct
WHERE raw_date > '2001-12-31'
AND ts_client_id = 93
AND ts_server_id IS NOT NULL;
It took about 4 minutes to complete so I EXPLAINed it:
NOTICE: QUERY PLAN:
Aggregate (cost=3
How can I transform the log transaction file in SQL?
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Can I have a log file per databases create?
How I manage this log file?
What are the command for these manage?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
En caso de que la base de datos se vaya a caer que pasos debo seguir para
levantarla Utilizando el log de transacciones
Att
Luis Andaluz
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
No tengo ningun problema, solo quisiera saber que debo hacer en caso de que
la base se llege a caer y no quiera funcionar.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmai
Hello,
first I'm sorry for my english, but I hope you can understand my following
problems and questions.
as I spent much time in getting information about the posibilities with
authentification in postreSQL there are some questions left. I didn't found
any answers to this questions so I hope yo
<>
Hello,
first I'm sorry for my english, but I hope you can understand my following
problems and questions.
As I spent much time in getting information about the posibilities with
authentification in postreSQL there are some questions left. I didn't found
any answers to this questions so I hope you
What's up here ? Google is deathly silent.
bash-2.05a$ pg_dumpall > db.out
connected to template1...
dumping database "MyPgSQLTest"...
dumping database "bb1"...
dumping database "bbadmin"...
pg_dump: [archiver (db)] connection to database "bbadmin" failed: FATAL
1: SetDatabaseEncoding(): inva
On Tue, Jul 29, 2003 at 10:38:50AM -0400, Tom Lane mentioned:
> A quick-and-dirty nostrum that sometimes helps for this sort of thing
> is "vacuum full pg_database". (The idea is to get rid of dead tuples
> that a new backend might be accidentally picking instead of the live
> ones --- it has to r
On Tue, 2003-07-29 at 17:55, Tom Lane wrote:
> Hm, that datdba field actually is NULL, isn't it? That's what you need
> to fix. The low-level code isn't expecting it to be NULL, and falls
> over in surprising ways. (Recent releases try to enforce NOT NULL on
> system catalog columns that mustn't
On Wed, 2003-07-30 at 15:26, Tom Lane wrote:
> "Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> > ""John P. Looney"" <[EMAIL PROTECTED]> writes:
> >> bbadmin | | SQL_ASCII
>
> > For sure a way to obtai
What's up here ? Google is deathly silent.
bash-2.05a$ pg_dumpall > db.out
connected to template1...
dumping database "MyPgSQLTest"...
dumping database "bb1"...
dumping database "bbadmin"...
pg_dump: [archiver (db)] connection to database "bbadmin" failed: FATAL
1: SetDatabaseEncoding(): inva
It was released couple of days ago. now i have a problem. i tried to
install to work with 7.3.4 on FreeBSD box ( cvsuped to stable) w/o luck.
i have problems with build:
any ideas?
alex
- error !!! --
[EMAIL PROTECTED]/za_install/erserver_v1.2]%
59 matches
Mail list logo
