SLONY should be the choice :)On 4/14/06, Pierre LEBRECH <[EMAIL PROTECTED]> wrote:
Hello,I want to replicate my PostgreSQL database at an other location. Thedistance between the two locations should be around 10 miles. The link
should be a fast ethernet dedicated link.What would you suggest me to d
I just tried it going to contrib/tsearch2 folder and then did the following:makemake installIt created a tsearch2.so file in the lib directory of pgsql which is used while registering the tsearch2 functions. Make sure you have that .so file created under the lib folder of pgsql.
Hope this helps.../
ECPG can be a good replcement for Pro*C You can see the detailed documentation for that at http://www.postgresql.org/docs/8.1/interactive/ecpg.html
Hope this helps.../ShoaibOn 4/19/06, koji osada <[EMAIL PROTECTED]> wrote:
I'm planning to migrate database from Oracle to PostgreSQL.I think there are
I dont think so you can modify the database encoding ... solution would be recreate it with the changed encoding
/ShoaibOn 5/2/06, Rodrigo Sakai <[EMAIL PROTECTED]> wrote:
Hi,
Is it possible to modify the encoding of a
production database? Or the only way is to create a new database
Try using\c dbnameand if you want to get rid of the
asking password thing you can change your authentication method from
'md5' to 'trust' in your pg_hba.conf file and then reload the settings
using "pg_ctl reload"
/ShoaibOn 5/23/06, Tahir Tamba <[EMAIL PROTECTED]> wrote:
Hi Guys,I install Postgres
re ignored.
Thank again for your helpTahir Tamba
De: Shoaib Mir <[EMAIL PROTECTED]>
Date: Mardi, Mai 23, 2006 1:33 pm
Objet: Re: [ADMIN] Authentication troubleshooting using psql
> Try using > > \c dbname > > and if you want to get rid of the asking password thing
HI Michael,You can try using an addon like pgjobs (http://gborg.postgresql.org/project/pgjobs/projdisplay.php)Thanks,Shoaib Mir
EnterpriseDBOn 7/21/06, Michael Grossman <[EMAIL PROTECTED]> wrote:
Hi!
I am using PostgreSQL 8.1.3 Windows version and pgAdmin
1.4.3
I
You can also try using 'pg_dumpall' (http://www.postgresql.org/docs/8.1/static/app-pg-dumpall.html) that will take the dump of all the users, groups and databases.
Thanks,Shoaib MirEnterpriseDBOn 7/25/06, Paul S <[EMAIL PROTECTED]> wrote:
It looks like it's a user configuration issue. I have hit u
You have to enable "stats_command_string' in your postgresql.conf file:stats_command_string = onAfter that is done you can view queries running on database server like this:select current_query from pg_stat_activity;
You can also get the query execution times and which queries were run, in the data
} # log version of backup open (FILEOUT, "> /tmp/OMEmaint") or die "Couldn't open OMEmaint for writing\n";
print FILEOUT "version=$dbAdmin_version\n"; close (FILEOUT);I will try modify the 'pg_dump' to 'pg_dumpall' and see if it
That appears to be the JDBC driver is not able to connect to the PostgreSQL database.Try out the following:- See if there is any firewall running, run 'iptables -F" on the database server machine to disable it for a while and then test the same Java code
- Check the routing tables info and see if t
Do you have any antivirus running on your system? if so, try disabling that. This problem can occur if some other process is holding a lock on that specific file and so as a result not able to rename the file.
Thanks,-- Shoaib MirEnterpriseDB (www.enterprisedb.com)On 7/31/06, Benjamin Krajmalnik <
Have a look at http://www.powerpostgresql.com/PerfList/ and change your settings accordingly.Thanks,-- Shoaib MirEnterpriseDB (
www.enterprisedb.com)On 8/1/06, Javanesevn <[EMAIL PROTECTED]> wrote:
Hi all,My project ( web application) is using Postgre 8.1 and PHP 4.x (ADOlibrary to access database)
You can use Slony (http://gborg.postgresql.org/project/slony1/projdisplay.php) for replication (data synchronization) and it also does offer the failover (not automatic) feature as well.
You can also have a combination of Linux HA + Slony for high availablity.-- Shoaib MirEnterpriseDB (www.enterpr
Please use MINGW for that purpose, haven't tried Visual Studio but MINGW does work on Windows without a problem.Thanks,-- Shoaib MirEnterpriseDB (www.enterprisedb.com
)On 9/18/06, Jeanna Geier <[EMAIL PROTECTED]> wrote:
Hello Again-I'm sorry to post this again; I was hoping someone would have respo
Try using the fast shutdown switch with pg_ctl i.e. -mf, that might help.Thanks,-- Shoaib MirEnterpriseDB (www.enterprisedb.com)
On 9/21/06, Mr. Dan <[EMAIL PROTECTED]> wrote:
Hi,We had to kill postmaster, and it's been ugly. The last backup finishedsuccessfully not last night, but the night befo
http://www.postgresql.org/docs/8.1/static/diskusage.html can help you get this information.Thanks,-- Shoaib MirEnterpriseDB (
www.enterprisedb.com)On 9/21/06, Guido Barosio <[EMAIL PROTECTED]> wrote:
there used to be a dbsize project, search for it.g.-On 9/21/06, Rodrigo Sakai <[EMAIL PROTECTED]> w
I guess that might work:1. Set the following in postgresql.conf file --> log_rotation_age = 12. rename the already present log file from dbserver logs folder3. Now do --> pg_ctl reload (so that log_rotation_age change you did comes in affect)
4. Check the log folder after a while (after 1 minutes)
There is this project which actually is not released yet, but something that you want to achieve :)http://pgfoundry.org/projects/pgpitrhaRegards,---
Shoaib MirEnterpriseDB (www.enterprisedb.com)On 10/30/06, Ben Suffolk <
[EMAIL PROTECTED]> wrote:> Guys,>> I have been thinking about this and wan
ots of them available in market, but i think WAL solution should be available, if not then the thought process should be there going ahead. I am expecting a solution out of WAL logs. Let me know if you have any thoughts about it.
Regards,Moiz KothariOn 10/30/06, Shoaib Mir <
[EMAIL PROTECTED]> wro
s,Moiz KothariOn 10/30/06, Shoaib Mir <
[EMAIL PROTECTED]> wrote:
Hi Moiz,If I had to choose for your case where you want to direct your selects to slave node and inserts/updates on master, I would have opted for Slony or PGCluster.
Using PITR for HA can be a good option if you want to switch between
Hi Moiz,This might help you :) --> http://developer.postgresql.org/pgdocs/postgres/warm-standby.htmlThanks,---Shoaib Mir
EnterpriseDB (www.enterprisedb.com)On 10/30/06, Andrew Sullivan <
[EMAIL PROTECTED]> wrote:On Mon, Oct 30, 2006 at 06:41:54PM +0530, Moiz Kothari wrote:
>
log to that point and then start applying the new WAL logs. Am i thinking it correctly or there is some flaw here.
Also if i am thinking it right, then how can i find the details i asked above.Regards,Moiz KothariOn 10/30/06, Shoaib Mir <
[EMAIL PROTECTED]> wrote:
Hi Moiz,This might help you
egards,Moiz
On 10/31/06,
Shoaib Mir <[EMAIL PROTECTED]> wrote:
Moiz,H, I think pg_controldata output might help you there to get these stats. pg_controldata can be found in the PostgreSQL /bin folder.Thank you,---------Shoaib Mir
EnterpriseDB (
www.enterprisedb.com)On 10/31/06, Moiz Kotha
Another very good resource is the PostgreSQL documentation itself --> http://www.postgresql.org/docs/8.1/static/index.htmlThanks,---
Shoaib MirEnterpriseDB (www.enterprisedb.com)On 11/2/06, Mark Steben <
[EMAIL PROTECTED]> wrote:
Good afternoon,
I am a database
administrator
If you don't need the client connection after query has executed then just close that client connection or you can have it set in your firewall to kill such idle connections who are not doing anything.Thanks,
Shoaib MirEnterpriseDB (www.enterprisedb.com)On 11/10/06, jose fuenmayor <
[EMAIL
You can get that from here -->
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.2.0%2Fwin32%2Fpostgresql-8.2.0-1.zip
Regards,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
I just uninstalle
Windows installer has pgAdmin bundled in, which can serve as a very easy to
use database administration software.
Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
Thanks for install link.
Can anyone recommend
Once you have installed PostgreSQL you can now use the ANSI or Unicode ODBC
driver from the ODBC driver manager in Windows as it gets installed
automatically during installation.
Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/10/06, Philippe Salama <[EMAIL PROTEC
Glad to hear that it worked out good for you :-)
Thanks,
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
Thanks Shoaib. You are perfectly correct! After I installed postgresql,
but without installing any odbc driver, I w
All looks according to the logs to me...
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/11/06, Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote:
Hi List ,
I restored the filesystem backup tar and ran postgres 7.3.8 on the data
folder.
there was no problem at all.
I meant "all looks *good* according to the logs" :)
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/11/06, Shoaib Mir <[EMAIL PROTECTED]> wrote:
All looks according to the logs to me...
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/11/
Have you tried using 'iconv' for cleaning up the invalid UTF8 character? In
case of big files you can always split them.
-----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/12/06, Manuel Trujillo <[EMAIL PROTECTED]> wrote:
Hi!
Firs, I will apologize abou
Exactly the same I too got as output without getting a bug in ver 8.2 :)
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hm, i can't see any bug here:
template1=# \di+
No relations found.
template1=#
Work
You can get the latest easy to use installer from
http://www.postgresql.org/ftp/binary/v8.2.0/win32/
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/6/06, Aleksander Slavchev <[EMAIL PROTECTED]> wrote:
Hi!
I need to build data replication with PostgreSQL, BUT! on W
To me PITR looks like a very nice solution for incremental backup and even
they can serve as a warm standby. What exactly are the complications you see
with WAL archiving?
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/13/06, Eduardo J. Ortega <[EMAIL PROTECTED]>
tml)
Hope this helps....
--------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/13/06, Eduardo J. Ortega <[EMAIL PROTECTED]> wrote:
Hi:
Well, I don't really like the fact that admin has to specify the archiving
and
restoring command; an error here (a lack of -i in cp, fo
They are physically stored in the PGDATA folder, for example on a default
windoze installation you can find it at:
C:\Program Files\PostgreSQL\8.2\data
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/13/06, Antonios Katsikadamos <[EMAIL PROTECTED]> wrote:
To be more precise they are in PGDATA\base...
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
On 12/13/06, Shoaib Mir <[EMAIL PROTECTED]> wrote:
They are physically stored in the PGDATA folder, for example on a default
windoze installation you can find it at:
C:\P
Can you please show the dbserver logs and syslog at the same time when it
goes out of memory...
Also how much is available RAM you have and the SHMMAX set?
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/15/06, Thomas Markus <[EMAIL PROTECTED]> wrote:
Hi,
i'm
Looks like with 1.8 GB usage not much left for dump to get the required
chunk from memory. Not sure if that will help but try increasing the swap
space...
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/15/06, Thomas Markus <[EMAIL PROTECTED]> wrote:
Hi,
logfile c
get around this
problem...
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/15/06, Sandy Spence <[EMAIL PROTECTED]> wrote:
Hi all admins,
Even though I am new to postgres I have been given the job of
administrator,
in at the deep end you might say.
We have a cr
o not sure if the above queries will work in it
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/15/06, Sandy Spence <[EMAIL PROTECTED]> wrote:
Hi Shoaib,
My problem is to determine which user/s this/these is/are, I believe we
have had a pg_dump problem long be
Well I will not recommend deleting rows like this from the meta data, but if
I will rather try using ALTER TABLE and ALTER TYPE to assign an owner for
the missing user referenced type or table
For example --> ALTER TYPE name OWNER TO new_owner
----
Shoaib Mir
Enterpris
Agreed, that will be a good solution for this scenario...
Thanks,
-
Shoaib Mir
EnterpriseDB (www,enterprisedb.com)
On 12/15/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Shoaib Mir" <[EMAIL PROTECTED]> writes:
> Well I will not recommend deleting rows like this f
Glad to hear that Sandy :)
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/18/06, Sandy Spence <[EMAIL PROTECTED]> wrote:
Hi Tom and Shoaib,
Thanks for all your help, the penny dropped and I now understand what you
meant by SYSID. I have traced the usename and
You can try creating the missing clog file as 256K of zeros, once that is
done you can now try going through the pg_dump process again.
This suggestion might help you as well -->
http://archives.postgresql.org/pgsql-admin/2003-02/msg00263.php
-----
Shoaib Mir
Enterpris
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
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
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
I am not sure if these option were supported with 7.3 (never used it) for
logging but that does go good with 8.1 and onwards...
Why don't you install the latest PostgreSQL release and test that out?
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/26/06, [
'EnterpriseDB Management Server' (
http://www.enterprisedb.com/products/enterprisedb_mgmtsvr.do) can be a good
option as with your requirements
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/27/06, Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote:
You can use the COPY (
http://www.postgresql.org/docs/current/static/sql-copy.html) command for
doing so
An example will be -->
COPY (SELECT * FROM country WHERE country_name LIKE 'A%') TO
'/usr1/proj/bray/sql/a_list_countries.copy';
-----
Did you try Slony with PostgreSQL?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/4/07, anorganic anorganic <[EMAIL PROTECTED]> wrote:
Hello,
i need make with postgre something as this:
i have two servers S1 and S2, connection is quit good, but sometimes once
or
What is your current logging level that is been set in the conf file?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/4/07, Ming <[EMAIL PROTECTED]> wrote:
Hi, I recently upgraded from 8.1.4 to 8.2.0, everything was fine
except that I suspect that the autovacuum w
Use pg_dump/pg_dump utility to take the db dump and then you can restore it
using psql or pg_restore at your end.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/4/07, Josef Springer <[EMAIL PROTECTED]> wrote:
Hi folks,
i must analyze a customer's database o
reconnecting to the database and it
should go fine this time....
--------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Josef Springer <[EMAIL PROTECTED]> wrote:
Hi folks,
i have a workgroup (not a classic server) with Windows-XP-machines:
the database server
as it was
before.
------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Josef Springer <[EMAIL PROTECTED]> wrote:
Hi Mir,
thanks for your quick answer. We will try this.
For my unterstanding: Why should i use *trust *instead of *md5 * ? A
configuration at another
Even with ver 8.1 you can use WAL archive backups (PITR) to implement an
incremental backup strategy.
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/17/07, Andy Shellam (Mailing Lists) <
[EMAIL PROTECTED]> wrote:
I believe the option for a "warm standby" (w
Yes, I guess that is true with 8.2 but with a few configurations for WAL
copying scripts.
Saw the following in documentation that specifies a good flow for doing it
--> http://www.postgresql.org/docs/8.2/static/warm-standby.html
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/18/07, Yogvinder Singh <[EMAIL PROTECTED]> wrote:
pg_dump is a utility for saving a PostgreSQL database into a script or an
archive file. The script files are in plain-text format and contain the
SQL
commands required to recon
Can we compare the same powerful like Oracle has on Xml?
I don't think so that current xml2 support is according to the SQL 2003
standards and for now it is I guess just the basic one.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/22/07, Rajesh Kumar Mallah &l
Do we have XML docs indexing mechanism in the todo's for 8.3? as this is one
of the problem I faced while moving the Oracle like XML functionality to
PostgreSQL using xml2 contrib.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/24/07, Peter Eisentraut <[EMAIL P
The following will explain in detail how Oracle handles the XML data and
also the indexing and searching mechanism for it:
http://www.oracle.com/technology/oramag/oracle/04-sep/o54xml.html
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/24/07, Peter Eisentraut <[EM
'citext' module (http://gborg.postgresql.org/project/citext/projdisplay.php)
might help you with this
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/25/07, Alexander B. <[EMAIL PROTECTED]> wrote:
Hi,
One developer asked me about case-sensitive, if its
It looks like to be a data corruption case a few cases like this have
been discussed in the past as well. The following link -->
http://archives.postgresql.org/pgsql-general/2006-12/msg01546.php might help
you resolve the problem.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.
It already is there in the contrib folder within the source. While in the
tsearch2 folder you just need to do a 'make' and 'make install' and then
then run the tsearch.sql file so that you can register the tsearch2
functions.
--
Shoaib Mir
EnterpriseDB (www.enterpri
yes, you need to just correct the build directory paths...
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/2/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
Στις Παρασκευή 02 Φεβρουάριος 2007 14:05, ο/η Alexander B. έγραψε:
> I am getting the follow error:
>
> ana
If you can tell the specific error on start/stop then someone might be able
to help you with this...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/2/07, Manish Pillai <[EMAIL PROTECTED]> wrote:
Hi all,
I have two production server .One ia already live and the other is
go
porting and
Logging" at
http://www.postgresql.org/docs/7.4/interactive/runtime-config.html
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/2/07, Manish Pillai <[EMAIL PROTECTED]> wrote:
Hi,
I am getting only this much...
[EMAIL PROTECTED] init.d]# ./postgre
A cron job can always do the job using pg_dump/pg_dumpall, in case you need
the incremental backup you can opt for PITR WAL based archive logs...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/3/07, Joshua Kramer <[EMAIL PROTECTED]> wrote:
Hello All,
What strategies are people
Use SIGTERM for killing only one process. You can also use kill -INT. It
sends a query cancel to the backend and will not disturb other processes and
the database server.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/3/07, Robert D Oden <[EMAIL PROTECTED]> wrote:
Thank you f
Going with a PostgreSQL backup user (with read only permissions) seems to be
a better option for your case
Anyone else on the list might be able to come up with much better options.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/3/07, Phillip Smith <[EMAIL PROTECTED]> wrote:
Hmm that should be 'org.postgresql.driver', you can find more details on
--> http://jdbc.postgresql.org/
I will recommend you to post such question on the JDBC list in future as you
will get a lot more help there...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/31/07,
Hmmm that looks like to me a HW problem causing data corruption. Try doing a
REINDEX for the database, if possible restart the database server machine
and then try taking the dump again to see if that works.
But I will recommend doing memory tests for the hardware...
--
Shoaib Mir
EnterpriseDB
What do you mean by indentical here? does it mean that they are same in
size, if that is true then yes they should be same in size unless you
specify archive_timeout (8.2 config parameter) setting to do a log switch
after certain amount of time.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com
Are the stat collector and autovacuum processes in good shape?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/16/07, Jeff Frost <[EMAIL PROTECTED]> wrote:
I've got a client that has a function in a db which had been humming along
quite nicely on 2xOpteron 275, PG 8.1.5,
First of all run the VACUUM FULL ANALYZE and that should hopefully help you
get rid of this problem without changing the max_fsm_pages. Other then this
I will recommend you to have the autovacuuming process in place for proper
database maintenance.
--
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
You can use the following query to get all the views:
select 'CREATE VIEW '||viewname||' AS '||definition as viewSQL from pg_views
where schemaname='';
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 4/2/07, Arnau <[EMAIL PROTECTED]> wrote:
Hi all
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
It actually is:
pg_ctl --help
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/11/07, Abraham, Danny <[EMAIL PROTECTED]> wrote:
Hi,
I am building a Windows installation by copying all the .exe and .dll
files to a single \bin file.
I am, then, testing by running "p
You can also use the following query to check the autovacuum activity:
select last_autovacuum, last_autoanalyze from
"pg_catalog"."pg_stat_all_tables"
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/20/07, Ireneusz Pluta <[EMAIL PROTECTED]> wrote:
Sibte A
Slony can handle this all.
If you do not want to use Slony, you can write your own triggers using
dblink module to get the data across.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/25/07, Mary Anderson <[EMAIL PROTECTED]> wrote:
Hi all,
I am new to postgresql and hav
I didnt meant for the version, what i meant was all on latest.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/25/07, Chris Browne <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] ("Shoaib Mir") writes:
> Slony can handle this all.
No it can't. It will n
Windows server to Linux as I think you can not use the data files created by
initdb on Windows for a Linux server.
--
Shoaib Mir
Fujitsu Australia Software Technology
[EMAIL PROTECTED]
ages when accessing
> the data.
>
> Is there a way to automatically convert the offending characters, or to
> easily locate them in a pg_dump file so they can be converted by hand?
>
>
Try using 'iconv' for your dump file and convert it all to UTF8 first before
restoring to a
ed the table it didn't delete the record from
pg_rewrite was not deleted when the parent table was dropped. So you can try
doing something:
delete from pg_rewrite where oid = 16403;
And see if this can fix the problem..
--
Shoaib Mir
Fujitsu Australia Software Technology
[EMAIL PROTECTED]
ces. Tweak the shared buffers and work_mem settings as well.
--
Shoaib Mir
Fujitsu Australia Software Technology
[EMAIL PROTECTED]
pgFouine --> http://pgfouine.projects.postgresql.org
--
Shoaib Mir
http://shoaibmir.wordpress.com/
ns for that? Details
for those options can be found at
http://www.postgresql.org/docs/8.3/static/kernel-resources.html#SYSVIPC
--
Shoaib Mir
http://shoaibmir.wordpress.com/
ing server, can i do this without full restart?
>
>
Which settings you want to change? as there are some which can be done with
just a database reload but some of them cant be done without doing a
database restart (like some memory related settings)
--
Shoaib Mir
http://shoaibmir.wordpress.com/
ig file some in of this settings exists comment line like
> "changes require restart". This is mean exactly restart or reload can do
> this?
>
>
>
For these you really need a database restart as reload will not help.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
e.
It will be easy to help if you can let us know of the offending row that is
giving the problem?
--
Shoaib Mir
http://shoaibmir.wordpress.com/
;
> There's no "SQL" way to know this, AFAICT. But I would love to be proven
> wrong: I would be able to add this info to pgAdmin, which would be great.
>
>
>
What about doing a query like:
show wal_level;
If it shows *hot_standby* then that server should have been
On Wed, Nov 10, 2010 at 1:17 PM, Tena Sakai wrote:
>
> Can somebody please tell me how I find who it is using the
> x database?
>
>
select * from pg_stat_activity where datname = '';
--
Shoaib Mir
http://shoaibmir.wordpress.com/
postgres successfully. Messages from the
> log:
>
>
>
> Dec 10 11:52:15 udrv postgres[771]: [ID 748848 local0.info] [6-1]
> host=,user=,db= LOG: setsockopt(TCP_NODELAY) failed: Invalid argument
>
Did ypu try deleting postmaster.pid file and then restarting??
--
Shoaib Mir
http://shoaibmir.wordpress.com/
On Fri, Dec 10, 2010 at 2:33 PM, Samuel Stearns
wrote:
> Thanks Tom and Shoaib,
>
>
>
> Shoaib, I did not delete postmaster.pid. I killed the children and
> re-started successfully.
>
>
>
So is the database server all good and working fine now??
--
Shoaib Mir
http://shoaibmir.wordpress.com/
98 matches
Mail list logo
