On Mon, Aug 29, 2011 at 11:21 AM, planas wrote:
> **
>
> CREATE TABLE "*ContactUpdates"*
> (
> "VendorID" integer NOT NULL,
> "LastName" character varying(45),
> "FirstName" character varying(45),
> CONSTRAINT "ContactUpdates_pkey" PRIMARY KEY ("VendorID" )
>
ERROR: relation "countupdates
On Thu, Aug 25, 2011 at 2:03 PM, Adarsh Sharma wrote:
> Dear all,
>
> I am using PostgresPlus-8.4SS version of Postgres on Linux & Windows
> Systems.
> Now I need to enable replication of two servers. OS may be same or
> different.
>
> Please let me know any useful links to do that.
>
I am not re
On Thu, Aug 25, 2011 at 11:57 AM, Toby Corkindale <
toby.corkind...@strategicdata.com.au> wrote:
>
> It seems messy to inherit the columns but not the indexes or checks upon
> them :(
>
>
>
Yes it can be a bit annoying at timse but you can try to automate the whole
process as well. Like I found th
On Thu, Aug 25, 2011 at 11:17 AM, Toby Corkindale <
toby.corkind...@strategicdata.com.au> wrote:
>
> Do I need to make sure I re-create every index on every child table I
> create?
> That would be.. annoying, at best.
>
> Is there a way to enable inheritance of indexes too?
>
>
You do not need an
to replay the files. Now if we cant have that
shared location and a scenario where all slaves and the master cant see one
shared location, how to approach this?
cheers,
--
Shoaib Mir
http://shoaibmir.wordpress.com/
On Fri, Dec 10, 2010 at 2:53 PM, Shoaib Mir wrote:
>
>
> On Fri, Dec 10, 2010 at 2:44 PM, gvim wrote:
>
>> I'm migrating a database from MySQL and need to keep the original `id`
>> column (AUTO_INCREMENT) intact so my plan is to create an simple integer
>>
this possible/the best solution? Maybe a migration utility would be
> better? Suggestions?
>
>
Try using SERIAL datatype.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
On Tue, Nov 9, 2010 at 3:22 PM, Victor Hooi wrote:
>
> *4. MS Access to Postgres*
>
>
>
Hmm have you tried Kettle (Pentaho) http://kettle.pentaho.com/
> Any particularly good books here that you'd recommend?
>
http://www.2ndquadrant.com/books/
--
Shoaib Mir
http://shoaibmir.wordpress.com/
il addresses but use the
community mailing lists for that.
For the error you mentioned please follow the steps I mentioned in my last
email as you are doing it the wrong way.
Create a sequence first and then you can assign that sequence to this
column. You can not assign SERIAL like this, it has to be
On Fri, Oct 29, 2010 at 3:58 PM, venkat wrote:
> Dear All,
>
> I got the solution... Here is my query
>
> ALTER TABLE DemoTable ALTER gid TYPE INT2;
>
>
>
Are you sure that you have converted here to a SERIAL type?
--
Shoaib Mir
http://shoaibmir.wordpress.com/
nce for the column (set the start of sequence according to
the values you got already in the column)
- Now set this sequence as the default value for that specific column which
you need to ALTER like this:
ALTER TABLE tablename ALTER COLUMN columnname
SET DEFAULT nextval('newsequence&
gt; would be no interruption to the web servers.
>
>
I have used Rubyrep for such scenario in the past but that was for a small
database so it didn't give me much trouble.
http://www.rubyrep.org/
--
Shoaib Mir
http://shoaibmir.wordpress.com/
short period of time so
> that no updates are being performed anywhere.
There is something that I saw the other day in PG 9.0 i.e.
transaction_read_only which might be helpful in your case.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
wesome to have such support as cascading at times is really
helpful. But again comparing to other third party solutions it seems just
very simple to setup for replication and sure does work nice. I cant wait
for 9.1 already :)
Regards,
--
Shoaib Mir
http://shoaibmir.wordpress.com/
s to make B the new master and have my
replication look like this:
B --> C
B --> A
Where are the steps I need for doing so?
Thanks,
--
Shoaib Mir
http://shoaibmir.wordpress.com/
... but Tcl and no PHP? I figure there's a tech
> reason for this - the demand must be there! No?
>
>
There is one already: https://public.commandprompt.com/projects/plphp
--
Shoaib Mir
http://shoaibmir.wordpress.com/
7;t seen
something like this in PLPSQL functions myself
--
Shoaib Mir
http://shoaibmir.wordpress.com/
8.4.3 on i686-pc-linux-gnu, compiled by GCC gcc (Ubuntu
4.4.1-4ubuntu9) 4.4.1, 32-bit
(1 row)
--
Shoaib Mir
http://shoaibmir.wordpress.com/
re of lobj_lock_table?
>
This is not a PgPool mailing list, please post it to the appropriate list
such as http://lists.pgfoundry.org/pipermail/pgpool-general/
<http://lists.pgfoundry.org/pipermail/pgpool-general/>
--
Shoaib Mir
http://shoaibmir.wordpress.com/
t;http://people.planetpostgresql.org/devrim/index.php?/archives/43-How-to-install-PostgreSQL-9.0-Beta-1-to-FedoraCentOSRHEL.html>and
see if that fixes the problem.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
gard,
>
Setup your log_line_prefix and log_statement setting properly in
postgresql.conf so that you get the user info and other appropriate details.
After that you can tail the DB server log file and grep for that specific
user to get what sort of SQL is been executed.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
software was running on the system
as well. If you have such installed can you try removing it and then see how
it goes?
--
Shoaib Mir
http://shoaibmir.wordpress.com/
filled file as I mentioned in my last email.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
hem filled with
zeros that server complaints for like the we just saw "pg_clog/",
remember this way you might be able to start the server but you will lose
the data from the time after your last checkpoint.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
to startup process failure
>
Try using pg_resetxlog to reset the control info on the DB cluster. Once you
have done that try re-starting and hopefully that should work then, but you
will I think lose everything from the last checkpoint by using pg_resetxlog.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
;
FOR i IN REVERSE LENGTH(original)..1 LOOP
reverse_str := reverse_str || substr(original,i,1);
END LOOP;
RETURN reverse_str;
END;$_$
LANGUAGE plpgsql IMMUTABLE;
--
Shoaib Mir
http://shoaibmir.wordpress.com/
On Wed, Feb 3, 2010 at 4:14 PM, Scott Frankel wrote:
>
> Hi all,
>
> Is it possible to specify a position when adding a column to a table?
>
>
Not possible, but have a read of
http://wiki.postgresql.org/wiki/Alter_column_position and look at the
alternative options.
-
exist or should I start writing my
> > own log parser?
>
>
I am not sure if its still available but there used to a nice tool for doing
the same, I guess it was named as "Playr" by myyearbook.
Regards,
--
Shoaib Mir
http://shoaibmir.wordpress.com/
s)
>>
>
>
>
Why don't you make it simple and just use row_number() from 8.4... It can be
simplified as:
select row_number() over(), i, p from prueba limit 5;
--
Shoaib Mir
http://shoaibmir.wordpress.com/
-->
http://www.postgresql.org/docs/8.3/static/runtime-config-logging.html
and then take a difference of settings between the two.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
ion "Linux Memory Overcommit at -->
http://www.postgresql.org/docs/8.3/interactive/kernel-resources.html
... that might help in this case
--
Shoaib Mir
http://shoaibmir.wordpress.com/
in your postgresql.conf file and reload.
For Client messages:
-
For client programs like psql, change the current locale where you are
starting up psql. I am not sure about windows but in Linux you can do this
by setting LANG environment variable.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
you have, copy it
to your desktop machine, build it and then build the .so file for contrib
module using 'make' and 'make install' once that is done copy the .so
from lib folder of PG to your production PG box's lib folder.
--
Shoaib Mir
Fujitsu Australia Software Technology
[EMAIL PROTECTED]
der
- run make and make install (this will copy pgstattuple.so file to the lib
folder of your PostgreSQL installation)
- Now from psql execute the pgstattuple.sql file for that specific database
which can be found in /share/contrib folder
- Once the sql file is executed now you can use the pgstattuple func
gt; Is there any reason why it's taking 220 seconds to run this simple
> query? There are about 3 million rows in this table.
>
>
Use the *'pgstattuple'* contrib module -->
http://www.postgresql.org/docs/current/static/pgstattuple.html
*pgstatindex* function from the co
Try using it with 'execute' as that might help...
OR:
CREATE TEMP TABLE tblname WITH (OIDS) ON COMMIT DROP AS select * from
someothertbl;
that means the temporary table will be dropped at the end of the current
transaction block.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
If you can use tcl based pl function, the this might help you here -->
http://sourceforge.net/projects/pgmail/
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/20/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Sean Murphy wrote:
> Maybe this is a well duh kind of questi
Something like this will help:
CREATE OR REPLACE FUNCTION import_text_file(char(255)) RETURNS void AS $$
DECLARE
filename ALIAS FOR $1;
fin varchar;
BEGIN
fin := 'COPY table from ' || filename;
execute fin;
END;
$$ LANGUAGE plpgsql;
--
Shoaib Mir
EnterpriseDB (www.enterp
key values exceeds work_mem"
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/11/07, rupesh bajaj <[EMAIL PROTECTED]> wrote:
Hi,
What is the meaning of 'materializing' a relation after sequential scan?
explain select * from tb1, tb2 where tb1.c1 = tb2.c2;
If you are on 8.1 you can use double qoutes ( 'C:\\Program Files\\My
program' ) on in 8.2 you can use the new "backslash_quote (string)"
setting.
You can find help on "backslash_quote (string)" at -->
http://www.postgresql.org/docs/current/static/runtime-conf
in your log file.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.co,)
On 5/29/07, Diego Fernando Arce <[EMAIL PROTECTED]> wrote:
show log_statement;
log_statement
---
all
(1 fila)
select pg_stat_get_backend_pid(s.backendid),pg_stat_get_backend_activity(
s.backendid) from (
Did you do a reload or restart of the server after doing this change?
what do you see when you do this query? --> show log_statement
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 5/29/07, Diego Fernando Arce <[EMAIL PROTECTED]> wrote:
this is a part of postgrsql.conf
log_
You can use the MSSQL DTS wizard for that purpose and using PostgreSQL ODBC
connector for target database connectivity there.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 4/5/07, M. Nejat AYDIN <[EMAIL PROTECTED]> wrote:
How can I migrate data from mssql to postgresql?
arameters. See the main PostgreSQL documentation for instructions on
this.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 4/2/07, Sorin N. Ciolofan <[EMAIL PROTECTED]> wrote:
Thanks,
I've a value of 1000 set for shared_buffers, does this means
that I u
Why dont you use the pg_dump (
http://www.postgresql.org/docs/8.2/static/backup-dump.html) utility of
PostgreSQL. Use the -s switch for taking just the schema and -a for taking
the data dumps. Try that and let us know if you face a problem doing so.
--
Shoaib Mir
EnterpriseDB
I guess shared_buffers (in postgresql.conf file) will help you here if you
have properly setup your kernel.SHMMAX value.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 4/2/07, Sorin N. Ciolofan <[EMAIL PROTECTED]> wrote:
Hello!
I'd like to ask you if there is
Yes, that is true if you have the autovacuum setting enabled for the
database server. You can see the last auto vacuum and last auto analyze
timestamp values from pg_stat_all_tables.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/21/07, Robert James <[EMAIL PROTECTED]> wrote:
I
It depends on the amount of memory you have...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/19/07, Ezequias R. da Rocha <[EMAIL PROTECTED]> wrote:
Hi list,
Could someone tell me the experience of many connections to PostgreSQL ?
I am my afraid if when PostgreSQL hav
s where viewname
= viewn into outp;
END IF;
end;
=====
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/11/07, Shoaib Mir <[EMAIL PROTECTED]> wrote:
I can see the following in pg_depend:
For view v1:
classid | objid |
-++--++--+-+-
_RETURN | 153521 | -1 | 1 | t | <>
_RETURN | 153524 | -1 | 1 | t | <>
Right now confused on how do I actually get the dependent views from this
kind of output... any ideas?
-
cant seem to get a simple output from it which
should be like this:
view_name | dependent_views
v1 |
v2 | v1
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
Try using something like this --> "Program Files/PostgreSQL/data" (that is
with quotes for using spaces)
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/8/07, Steven De Vriendt <[EMAIL PROTECTED]> wrote:
Hi all,
Got this kind of silly question. I'm trying to u
d every time you log in :)
psql mydb postgres mypwd
That is not the correct way, just as i mentioned change it to md5 and now
when you do
psql -d mydb -U postgres
It will ask for a password.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/8/07, George Heller <[EMAIL PROTECTED]> w
or ANALYZE manually and see if that gets
updated in the last_vacuum of pg_stats_all_tables.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/13/07, Walter Vaughan <[EMAIL PROTECTED]> wrote:
Shoaib Mir wrote:
> pg_stat_all_table view should help you:
>
> select last_autovacuum
So hmm a UNION with an ORDERY BY should be good for this scenario...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/13/07, Shane Ambler <[EMAIL PROTECTED]> wrote:
Shoaib Mir wrote:
> I guess UNION ALL should work good here instead of a UNION for the exact
> same kind
2 | E
3 | C
3 | F
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/13/07, Shane Ambler <[EMAIL PROTECTED]> wrote:
Ashish Karalkar wrote:
> Hello List,
>
> I want to append column of two different tables in a single column of a
view .
>
> data type of tow column of two
You can get the details at -->
http://www.postgresql.org/docs/8.2/static/backup.html
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/13/07, RPK <[EMAIL PROTECTED]> wrote:
We are planning a mission-critical client/server application and want to
use
PGSQL as backend to VB.NE
pg_stat_all_table view should help you:
select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/9/07, Sic Transit Gloria Mundi <[EMAIL PROTECTED]> wrote:
Hi,
I couldnt find this on google, the archives, or the manual
Yes, you can pass values to the scripts. Here is an example
Suppose the script file 'test.sql' is like this:
insert into test values (:chk1 , :chk2);
Now you can pass the variables using psql as:
psql -d test -U postgres -v chk1=5 -v chk2='abc' -f test.sql
Hope that
NSERT INTO test values (1);';
return 1;
end;
$$ LANGUAGE 'plpgsql'
used number by mistake so sorry for any inconvenience caused as I was
trying it with EnterpriseDB (where 'number 'is added for Oracle
compatibility)
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
O
Something like this will help you:
execute immediate 'create temporary table test (a number) on commit drop';
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/8/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Wed, Feb 07, 2007 at 20:40:09 -0800,
jws <[EMAI
see if the db server is running or not. You can do that using:
pg_ctl -D status
Once that gives a good status then you might have to tweak 'pg_hba.conf'
file to allow for users connecting to the database.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/2/07, gf <[EMAIL PROT
There is such timeout from the database server for the idle connections but
yes you can always use firewall settings in order to do that and kill idle
connections.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/6/07, Gurjeet Singh <[EMAIL PROTECTED]> wrote:
On 1/30/07, Alvaro H
nd then doing a
\df+ add
did show me the correct output...
You can also try the following to get the same type of results:
select proargtypes, prorettype, prosrc from pg_proc where proname =
'delete_old';
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/1/07, Harvey, Allan AC
Thank you Alvaro :)
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/30/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Shoaib Mir wrote:
> While debugging an application, I just wanted to confirm from the list
here:
>
> Suppose I have a long running transact
commit the client app crashes and the commit is never sent, will the
Exclusive locks be automatically released?
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
Decode works as expected for me
Try the following:
select decode((encode(E'\\000\\001', 'escape')::text), 'escape');
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/24/07, marcelo Cortez <[EMAIL PROTECTED]> wrote:
hi Markus ,folks
I think the way of doing that will be taking a schema backup using pg_dump
-n option and then restoring that again in the same database using a
different schema name with psql.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/24/07, johnf <[EMAIL PROTECTED]> wrote:
This might help you:
select encode(col1,'escape') from tblBytea;
where col1 is of type bytea...
-----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/24/07, marcelo Cortez <[EMAIL PROTECTED]> wrote:
folks
help me ,i cant read bytea type field's.
how to con
In order to move data and tables from MS SQL Server to PostgreSQL, use the
MS SQL Server DTS wizard and gave it the ODBC for PostgreSQL as the target
database.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/23/07, Robert Fitzpatrick <[EMAIL PROTECTED]> wrote:
On Mon
I dont have the replication setup on my machine right now but I guess as far
as I remember you can surely check for the master and slave nodes from a
Slony schema table.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 19 Jan 2007 08:25:23 -0800, [EMAIL PROTECTED] <[EM
s then you
should be using varchar(n).
-----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/20/07, Kelly Burkhart <[EMAIL PROTECTED]> wrote:
On 1/20/07, Shoaib Mir <[EMAIL PROTECTED]> wrote:
> Should help --> ALTER TABLE tablename ALTER columname TYPE text;
Should help --> ALTER TABLE tablename ALTER columname TYPE text;
----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/20/07, Kelly Burkhart <[EMAIL PROTECTED]> wrote:
On 1/19/07, Martijn van Oosterhout wrote:
>
> ALTER TABLE, to be correct, actually has to c
PostgreSQL functions.
You can find some good detail over here as well -->
http://www.postgresql.org/docs/techdocs.29
--------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/19/07, Paul Lambert <[EMAIL PROTECTED]> wrote:
G'day folks,
I'm faily new to the wor
lover when the master node goes down.
------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/19/07, Stéphane Schildknecht <[EMAIL PROTECTED]>
wrote:
Hello,
You should ask directly to the slony1 mailing list.
[EMAIL PROTECTED] a écrit :
> (...) The Slony version I'm usi
An old post on the archives might help you -->
http://archives.postgresql.org/pgsql-interfaces/2005-11/msg00010.php that
was an attempt to simulate functionality similar to setFetchSize in JDBC.
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Jan van der Wei
If you go with Java, you can make it faster by using setFetchSize (JDBC
functionality) from client and that will help you with the performance in
case of fetching large amounts of data.
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Jan van der Weijde <[EM
v_cnt > 0 THEN
v_tbl = 'true';
END IF;
IF v_cnt = 0 THEN
v_tbl = 'false';
END IF;
return v_tbl;
END;
$$ LANGUAGE 'plpgsql'
=
select check_table('emp', 'public');
---
Shoaib Mir
E
Oh yes, need to have a condition first for which you have partitioned
tables. Only in that case it will work with partitions.
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Richard Huxton wrote:
Shoaib Mir wrote:
> You can also opt for partitioning the tables
You can also opt for partitioning the tables and this way select will only
get the data from the required partition.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Richard Huxton wrote:
Jan van der Weijde wrote:
> Hello all,
>
> one of our customers
COPY command might also help
COPY (SELECT * FROM country WHERE country_name LIKE 'A%') TO
'/usr1/proj/bray/sql/a_list_countries.copy';
Details can be found at -->
http://www.postgresql.org/docs/current/static/sql-copy.html
------
Shoaib Mir
EnterpriseD
You can give EnterpriseDB PL Debugger a try, details for its usage can be
found at --> http://www.enterprisedb.com/documentation/debugger.html
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/14/07, Marcel Gsteiger <[EMAIL PROTECTED]> wrote:
thanks for responding.
how string literals will be processed. The presence
of this parameter can also be taken as an indication that the escape string
syntax (E'...') is supported. Escape string syntax should be used if an
application desires backslashes to be treated as escape characters.
-------
Sho
Can you show us the output for:
ps auxwww | grep ^postgres
that should explain a little more...
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/10/07, Ashish Karalkar <[EMAIL PROTECTED]> wrote:
Hello All,
I am running PostgresSQL 8.2 on Redhat Linux 4.
When I look f
It does install both the Slony binaries and scripts.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
Hello all,
When installing PostgreSQL via the Windows installer, Slony-I is one
of the options offered. Does it
It is used for Hierarchical queries in Oracle :)
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
> Hello everybody,
> In Oracle i use the command "connec
There is no default support but you can always use connectby() function from
the tablefunc contrib module
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Leandro Repolho <[EMAIL PROTECTED]> wrote:
Hello everybody,
In Oracle i use the command "connect by
Well I haven't use much of PGAdmin but I will always be using pg_dump and
pg_restore for that as they are really easy to use.
You can find help on backup and restore at -->
http://www.postgresql.org/docs/8.2/static/backup.html
----
Shoaib Mir
EnterpriseDB (www.enterpri
This should help you get the disk usage for a table:
select pg_size_pretty(pg_relation_size('tablename'));
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/28/06, 马庆 <[EMAIL PROTECTED]> wrote:
Maybe U can't get the disk usage info, but you can
ter in case of a
master node failure, and then you can actually do the load balancing by
using the slave nodes in the system.
Please let me know on any updates for OpenSSI if you get a chance to try
that out
---
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
On 12/26/06, And
that can
work for you, haven't tried that myself but will like to hear about
PostgreSQL configuration with OpenSSI
---
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
On 12/26/06, Andy Dale <[EMAIL PROTECTED]> wrote:
The company i am working for has a trail/evaluation li
Yes, that is true with pgpool. I did face the same as well.
There is another as well Uni-Cluster (
http://www.continuent.com/index.php?option=com_content&task=view&id=213&Itemid=170),
haven't tried yet but it might help you there...
-------
Shoaib Mir
EnterpriseDB (www
pgpool-II might help you there too I guess...
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/26/06, Andy Dale <[EMAIL PROTECTED]> wrote:
Hi,
I have just read the statement that Postgres does have (with end user
assembly) multi-master replication system. Is thi
In your SQL script file you can add at the start something like this:
set search_path = contrib
and that should take care of it without this change in psql.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/23/06, Paul Silveira <[EMAIL PROTECTED]> wrote:
ell.
-----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/25/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Thanks Chris,
I see you a core member of Slony team and a replication guru so I'll look
into it.
I'm not slamming Slony I think its probably the right tool for type o
d try it PostgreSQL on OpenSSI that will be a good info to have.
-----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/24/06, Lincoln Yeoh wrote:
At 08:12 AM 12/22/2006, Joshua D. Drake wrote:
>
> > With One Big Database, you can get a SAN and attach a whole lot of
> &g
Yes, ANALYZE should definitely improve the performance for query...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/24/06, Benjamin Arai <[EMAIL PROTECTED]> wrote:
Just to make things more clear I ran EXPLAIN ANALYZE on the slow query.
I got
Merge Full Join (cost
adding to the last email, for now try the work_mem but you should be
adding ANALYZE along with the VACUUM (with a cron job I guess) you do
regularly.
Shoaib Mir
EntperpriseDB (www.enterprisedb.com)
On 12/24/06, Shoaib Mir <[EMAIL PROTECTED]> wrote:
Try increasing the wo
Try increasing the work_mem first to see the change, that might help.
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/24/06, Benjamin Arai <[EMAIL PROTECTED]> wrote:
I have been running pieces of my PL function by hand and I have found
that the following queries w
I think you might want to do incremental backups so a better approach to
that as you mentioned too will be WAL files. For details you can refer to
--> http://www.postgresql.org/docs/current/static/continuous-archiving.html
----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
1 - 100 of 182 matches
Mail list logo
