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
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
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
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
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
>
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
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
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 resume an incomplete Pg-restore from a custom Pgdump file?
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
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
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
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
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
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
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.
--
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
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
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
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
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
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
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
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
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=&
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
-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
-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
approve vYyvLS unsubscribe pgsql-admin [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
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
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
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
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
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]%
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 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
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 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
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
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)---
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.
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? 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
---
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
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:
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:
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
-
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
<>
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
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
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]
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]
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
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
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!
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
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
59 matches
Mail list logo
