On Wed, Mar 27, 2013 at 1:43 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> On Wed, Mar 27, 2013 at 10:53 PM, Keith Ouellette <
> keith.ouelle...@airgas.com> wrote:
>
>> Is there a way to dump only functions to a directory with each function
>> as its own file in SQL format?
>>
> AF
On Tue, Feb 5, 2013 at 3:33 PM, Geoff Winkless wrote:
> Thanks for all the responses
>
> On 5 February 2013 19:36, Rosser Schwarz wrote:
>
>> On Tue, Feb 5, 2013 at 11:00 AM, Scott Mead wrote:
>>
>>> Agreed, don't forget, you have indexes, free sp
ifference.
> >
> > As I said, sorry if I've missed the obvious "use loads of extra space"
> setting but I'd appreciate any
> > suggestion as to what that setting might be called :)
>
> I don't think that pg_column_size() is a good tool to
On Thu, Apr 19, 2012 at 5:47 PM, Nagaraj Shindagi <
nagaraj.shind...@gmail.com> wrote:
> Hi team,
>
> i am nagaraj, i am newbi in this database world. i required your help.
> 2 dyas back i formatted one of my client system. which is having
> postgresql 8.2 database & that was having data. but i am
On Wed, Apr 18, 2012 at 10:12 PM, Rickard, David <
drickard1...@library.ucla.edu> wrote:
> We have a legacy PostgresSQL 7.3.4 db on Solaris which has recently (as
> in last 24 hours or so) begun refusing TCP/IP (JDBC) connections from the
> same server the db is on.
>
> The db is up and runni
On Thu, Jul 7, 2011 at 10:49 AM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> On 07/07/2011 02:04 AM, francescobocca...@libero.it wrote:
>
>> Dear all,
>> i tried to install postgresql 9.0 in my Linux Ubuntu 9.10.
>> ...
>>
>>
OpenSCG has deb's that will install cleanly:
http://www.o
--
Scott Mead
OpenSCG
PostgreSQL, Java & Linux Experts
http://openscg.com
On Wed, Mar 2, 2011 at 9:17 AM, Jason Clark wrote:
> Hey fellas,
>
> A little stumped here, maybe someone could give me some insight?
>
> I have set up a warm standby situation for testing before
On Thu, Feb 24, 2011 at 1:28 PM, Dolafi, Tom wrote:
> Hi,
>
> I am getting database shutdown issues as transaction wraparound limit hits
> 99.
>
> Here is the story...
> We recently inherited a system in which a postgresql 8.1.18 server hosts
> 700+ databases and growing. Essentially it is h
stuck on it. You'll have to create a
new standby from it, the old primary can't be used as a standby.
--Scott
>
>
> On Thu, Feb 17, 2011 at 9:36 AM, Scott Mead wrote:
>
>> On Wed, Feb 16, 2011 at 8:29 PM, Selva manickaraja wrote:
>>
>>> Dear All,
>
On Wed, Feb 16, 2011 at 8:29 PM, Selva manickaraja wrote:
> Dear All,
>
> We have a primary running continous archiving to a secondary. We managed to
> test fail-over to the secondary by stopping the database in the primary.
> Then some transactions were tested in the secondary. It was acting well
ions on your mountpoint? Are they too restrictive for
the postgres user? ( or any of the higher level dirs)
>
> Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
>
> On 02/15/2011 04:37 PM, Scott Mead wrote:
>>
>>
>>
>> On Tue, Feb 15, 2011 at 5:32 PM, S
with both -o and -c arguments.
>
My mistake, I screwed up!
/usr/lib/postgresql/8.4/bin/pg_ctl start -D
/media/extension/var/lib/postgresql/8.4/main/ -o "-c
config_file="/etc/postgresql/8.4/main/postgresql.conf"
(-c inside the quotes)
--Scott
Thanks,
> Sairam Krishnamurthy
gresql.conf"
--Scott
>
> Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
>
>
> On Tue, Feb 15, 2011 at 3:45 PM, Scott Mead wrote:
> >
> > On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy <
> kmsram...@gmail.com>
> > wrote:
> &
On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy
wrote:
> All,
>
> I am using Ubuntu 10.04 and Postgres 8.4, I have been trying to move
> my data dir to another device for the past couple of days but ran into
> a lot of problems.
>
> I did the following:
>
> 1. Copy the contents of /var/lib/p
On Sun, Feb 13, 2011 at 10:19 PM, Selva manickaraja wrote:
> Dear All,
>
> We had managed to setup and test the Continous Recovery of a secondary
> machine. What we need to achieve is for it to recover as primary in the
> event that primary fails. We know that we can use the "trigger_file" setting
On Sun, Feb 13, 2011 at 10:35 AM, Selva manickaraja wrote:
> Any updates?
You can't use any wal based replication like that. When a node is in
recovery mode, it doesn't log.
--Scottie
>
>
> -- Forwarded message --
> From: Selva manickaraja
> Date: Sat, Feb 12, 2011 at 1:43
On Fri, May 14, 2010 at 1:55 AM, Vinay Sarvana wrote:
> Hi. Is there any possibility for creating trigger file automatically in
> postgres. Scenario is as follows :
>
> There are some application which is having this postgres database. There
> are main & backup database. Application is normally co
On Wed, May 5, 2010 at 11:27 AM, raghu ram wrote:
> Hi Postgres Guru's,
>
>
> Is it possible to use the Hot Backup (PITR Backup) of PostgreSQL on an
> Operating system to restore the database on other Operating system.
>
>
> No, it isn't. Physical (PITR) backups are based on copying the physical
On Wed, Apr 14, 2010 at 2:38 AM, Justin Falk wrote:
> Hi,
>
> I'm trying to use the -j option on pg_restore while restoring a database
> into PG 8.4.3.
>
> The dump was executed on PG 8.3.7 (Windows, Server 2003) using:
>
> pg_dump -Fc -U postgres mydb > mydb.backup
>
> This results in a ~3.4 GB
On Tue, Apr 20, 2010 at 6:32 AM, Scott Marlowe wrote:
> On Tue, Apr 20, 2010 at 1:20 AM, Renato Oliveira
> wrote:
> > Dear all,
> >
> > It may sounds crazy it may not sound so crazy.
> >
> > I was here think are there any commands to watch new transactions rolling
> > through the screen like a te
On Thu, Apr 15, 2010 at 11:31 AM, Renato Oliveira <
renato.olive...@grant.co.uk> wrote:
>Dear all,
>
>
>
> I was reading again the documentation... “The archive command should
> generally de designed to refuse to overwrite any pre-existing archive file.”
>
> This means it will keep writing log
On Wed, Apr 14, 2010 at 1:42 PM, Kenneth Marshall wrote:
> On Wed, Apr 14, 2010 at 01:29:23PM -0400, Lewis Kapell wrote:
> > In the documentation under the heading "Migration Between Releases" we
> > read:
> >
> > < create
> > a slave server with the updated version of PostgreSQL. The slave can b
On Tue, Mar 23, 2010 at 7:18 AM, John Lister
wrote:
> Hi, I've successfully set up a slave system using WAL archiving and
> pg_standby, but I have a couple of questions.
>
> I have a couple of questions:
>
> Is it possible to stop the database server (for maintenance for example)
> and resume the
2010/3/19 Antoine POPINEAU
> Hi,
>
> I am developping a Java application, and using a PostgreSQL backend
> database. Theorically, there might be lots of users, each with potentially
> different permissions over the different tables.
>
> I could add those user to the database with a classic CREATE
Lots there, let's break it down individually:
On Mon, Mar 22, 2010 at 6:38 AM, blast wrote:
>
> Hi all,
>
> I need to backup and restore a DB.
> In this particular case the data in the database is not important (strange
> hum...) but only the schema to put new data...
>
> I m thinking use the p
On Wed, Feb 3, 2010 at 4:12 PM, Campbell, Lance wrote:
> PostgreSql:8.4.1
>
> Is there a way for me to tell postgres to clear the log file. Example: I
> have log files created with names corresponding to the days of the week.
> This way they overwrite each other every week. When I deploy soft
On Wed, Jan 20, 2010 at 6:48 AM, Kevin Grittner wrote:
> Renato Oliveira wrote:
>
> > I can't implement PITR right now on our live systems, for
> > commercial reasons.
>
> What do you mean? Most of your email seems to describe techniques
> very much like PITR; why would that be OK but the exist
On Mon, Dec 21, 2009 at 4:35 PM, Scott Marlowe wrote:
> On Mon, Dec 21, 2009 at 2:26 PM, Scott Mead
> wrote:
> >
> > On Mon, Dec 21, 2009 at 4:17 PM, Scott Marlowe
> > wrote:
> >>
>
>
> Yeah, I create a different "admin" account for each o
On Mon, Dec 21, 2009 at 4:17 PM, Scott Marlowe wrote:
>
>
> Yes, it's fine. Make a different data dir, point the postgresql.conf
> gile to a different tcp port and off ya go. I do it all the time to
> test slony setup at work.
>
Agreed, I've actually used it for a couple of different reasons, i
On Mon, Dec 14, 2009 at 10:32 PM, Net Tree Inc. wrote:
> Quick find out. Does anyone know how to shutdown or to stop a specified
> database on postgresql that runs few other databases???
Not quite the same no. In Postgres, if you do a:
pg_ctl -D stop
It will shut all processes down, th
On Thu, Oct 29, 2009 at 7:57 PM, Scott Mead wrote:
>
> On Thu, Oct 29, 2009 at 5:13 PM, dx k9 wrote:
>
>> Hi all -
>>
>> I'm trying to do a PITR and I've noticed that every time I try it, it ups
>> the number it's looking for by one.
>>
On Thu, Oct 29, 2009 at 5:13 PM, dx k9 wrote:
> Hi all -
>
> I'm trying to do a PITR and I've noticed that every time I try it, it ups
> the number it's looking for by one.
>
What's in your recovery.conf?
>
> 0001.history
> 0002.history
> .
> .
> 0008.history
>
> For example one
2009/10/26 Eduardo Sá dos Reis
> Hi,
>
> I have the structure on Postgre:
>
> *database*: dbGlobal
>
> *schema1:* sch_sist1 *owner *sch_sist1: john
>
> *schema2 *sch_sist2 *owner *sch_sist2: mary
>
>
> I' m using pgAdmin III.
>
> Is there a way to avoid the mary to ac
On Thu, Oct 22, 2009 at 1:28 PM, David Jantzen wrote:
> Thanks for the quick response Joshua, much appreciated. Is there any
> way to avoid or minimize a period without a warm standby when I switch
> to Server B for production? What about rsyncing the data directory
> from Server B to Server C
On Wed, Oct 21, 2009 at 3:05 AM, stefan wrote:
>
>
>
> Thanks, you were right, I added an additional commit which solved the
> problem. The hint was that the pg_lock view contained a lock entry which
> said granted "No".
>
> This raises though the question of isolation level, afaik postgres defau
On Tue, Oct 20, 2009 at 8:46 AM, stefan wrote:
>
> Hi,
>
> I have a postgres 8.3 db in which I execute a transaction with a lot of
> alter tabel etc, update etc statements in a single transaction.
> I also execute several select statements in parallel.
> This puts my database in a state which I w
On Wed, Jul 15, 2009 at 2:39 AM, Tom Lane wrote:
> Thomas Kirchtag writes:
> > 2009-07-08 21:28:06 CEST LOG: 0: pam_authenticate failed: Permission
> > denied
> > 2009-07-08 21:28:06 CEST LOCATION: CheckPAMAuth, auth.c:1345
>
> > This suggests some problems accessing some pam-related file
On Tue, Jul 14, 2009 at 4:05 PM, Isabella Ghiurea <
isabella.ghiu...@nrc-cnrc.gc.ca> wrote:
> Hello Gurus,
> From which internal tables/views I can get the user connection
> application/job name ? (pg_stat _activity has the client ip address only)
Unlike Oracle, PG doesn't give you the
On Thu, Jul 9, 2009 at 6:18 PM, Rafael Domiciano wrote:
> Hello People,
>
> Today, I've upgraded a dedicated postgres server, from 2 Gb to 10 Gb.
> Everything gone well.
>
> But, I would like shared buffers to use at least 5 Gb of the total memory.
>
What's your workload? Is this db primaril
On Tue, Jul 7, 2009 at 1:46 PM, Lewis Kapell wrote:
>
>>
> If you were planning to upgrade to 8.4 in the near future, then you
> wouldn't have to worry about these settings any more. Those settings tune
> themselves and they are no longer specified in the configuration file.
+1
The visibil
On Tue, Jul 7, 2009 at 1:40 PM, Jennifer Spencer
wrote:
> You are sure that the XID wraparound is gone? That's good news. No other
> reasons for vacuum full on the entire database.
>
I think we're talking apples and gorillas on the use of the word 'full'.
There is a command:
VACUUM F
On Tue, Jul 7, 2009 at 5:12 AM, Jennifer Spencer
wrote:
>
> >
> > If you've moved on, so to speak, with the new primary, you restart the
> > old primary, now warm standby, the same way you initially created the
> > warm standby. issue the start hot backup command to the primary, copy
> > over all
On Tue, Jun 30, 2009 at 11:26 PM, wrote:
> > I've backed up my DB via 'pg_dump dbname' using no options. In order to
> > restore it via psql, do I first need to drop the db instance and recreate
> > it?
> >
> > Thanks in advance for your help.
> >
> > -Mike
> >
> >
> >
> yes, you have to drop the
On Tue, Jun 30, 2009 at 11:26 PM, wrote:
> > I've backed up my DB via 'pg_dump dbname' using no options. In order to
> > restore it via psql, do I first need to drop the db instance and recreate
> > it?
> >
> > Thanks in advance for your help.
> >
> > -Mike
> >
> >
> >
> yes, you have to drop the
OP: Downgrade to your original version, then do a pg_dump.I'm not sure the
yum command to do this, but there must be some. To be version specific you
can look at the PG_VERSION file in your data directory.
On Tue, Jun 16, 2009 at 12:10 AM, Scott Marlowe wrote:
>
>
> This is NOT yum's fault. P
On Tue, Jun 9, 2009 at 10:31 AM, Roland Hughes
wrote:
>
> With RDB on OpenVMS, designed correctly, you lose nothing. Users and rights
> identifiers are provided by the OS as it integrates into the AUTHORIZE
> system. Single and multi-file databases are scattered about the entirety of
> the Files-1
On Tue, Jun 9, 2009 at 10:10 AM, Roland Hughes
wrote:
> On Tuesday 09 June 2009 08:55:18 am Tino Schwarze wrote:
>
>
> >
>
> > You just need to preserve everything from Postgres' data directory
>
> > (which shouldn't be much data).
>
> >
>
> While it shouldn't be much data, it is also non-robust.
On Tue, Jun 9, 2009 at 9:05 AM, Roland Hughes
wrote:
>
> > > I'm trying to avoid the pain of unload/recreate/reload when upgrading
> OS
>
> > > versions. In many cases, they don't even change the Postgres version.
>
> > > Unloading multiple TB of binary data to text then reloading is a major
>
> >
On Mon, Jun 8, 2009 at 1:23 PM, Roland Hughes
wrote:
> Hello,
>
> I have had a question for some time and cannot seem to find an answer.
>
> Is there a way to add pre-existing tablespace to a fresh Postgres install?
>
> Typically I create tablespace on some TB drives and place all databases
> the
On Fri, May 22, 2009 at 9:49 AM, Peter Eisentraut wrote:
> On Friday 22 May 2009 06:51:42 Cliff Pratt wrote:
> > I've browsed my history of the list, and the Internet for information
> > regarding giving the unix 'postgres' user a shell of /bin/false, so
> > that it cannot be logged into directly
>
>
>
> > I tried to put my password in a .pgpass file into the home directory of
> > the root user (so /root/.pgpass). Here is a cat of that file :
> > *:*:*:*:test
> >
> >psql: FATAL: authentification par mot de passe choue pour
> ...
> > When prompt for a password, I enter 'test' and it
On Fri, May 15, 2009 at 6:44 AM, J. Carlos Muro wrote:
> Hi! When I have more that one project, which is better, in terms of
> efficiency/organization?
>
> * Case A: Create one database, and for every project a new schema (in the
> oracle style) containing project's objects.
>
This method is
On Fri, Apr 10, 2009 at 3:39 PM, Tena Sakai wrote:
> Hi Everybody,
>
> I am having difficulty connecting to postgres service from
> a remote machine on the network.
>
> My postgres (8.3.6, on Linux) is running on a machine
> (vixen) and I would like to connect to it from another host.
>
> The ho
53 matches
Mail list logo