[ADMIN] psql data restore not working

I would be glad on advice what might be the issue (or how I could narrow it down) with the non restoration of data from a postgres 7.1 database to a postgres 8 database. The schema was dumped with pg_dump -O -s databasename > database_schema_file_name The data was dumped with pg_dump -O -a databa

Re: [ADMIN] WAL files during a backup

Hey Drew, Correct. This will all depend on what sort of backup system you are after. If you want to recover up to its existing state, you will need a script that will nab the current log, located in the x_log dir, and backup this up every x minutes. Along with this you will be backing up your WAL

Re: [ADMIN] privileges

Could it be the search path (schema) issue? Just a quick thought... Regards, Ben Kim On Thu, 28 Aug 2008, Carol Walter wrote: Hello, I asked this question yesterday, but perhaps I did so in an unintelligible way. I didn't get any answer that time. Someone usually answers my questions, s

Re: [ADMIN] Installing PostgreSQL 8.3.3. on Vista

Looks like the relevant Visual C runtime library ( VC80.CRT 32 bit ) needs installing first... Steve On Thu, 28 Aug 2008 09:42:54 -0500 "Brandon Dybala" <[EMAIL PROTECTED]> wrote: > I tried installing PostgreSQL 8.3.3 on Vista Business, and initdb failed > to start during the installer. I'd re

Re: [ADMIN] privileges

The problem is solved. It wasn't until I tried to work with the database in PhpPgAdmin that I got an error message that pointed me to the solution. I had not granted privileges to the schemas. I had never had to grant privs to a schema before and the documentation seemed to indicate that

Re: [ADMIN] privileges

On Thu, Aug 28, 2008 at 1:49 PM, Richard Broersma <[EMAIL PROTECTED]> wrote: > On Thu, Aug 28, 2008 at 1:37 PM, Carol Walter <[EMAIL PROTECTED]> wrote: > >> I granted the app_admin role to my user name. When I try to >> describe the table using the "\d" psql command, it tells me there are no >> r

Re: [ADMIN] privileges

On Thu, Aug 28, 2008 at 1:37 PM, Carol Walter <[EMAIL PROTECTED]> wrote: > I granted the app_admin role to my user name. When I try to > describe the table using the "\d" psql command, it tells me there are no > relations. I believe that this link explains the problem you are seeing: http://www

[ADMIN] privileges

Hello, I asked this question yesterday, but perhaps I did so in an unintelligible way. I didn't get any answer that time. Someone usually answers my questions, so I must not have asked it very well. I have a new database that I'm building for a faculty research project. I created a ro

Re: [ADMIN] excluding tables

Rick <[EMAIL PROTECTED]> writes: > Is there a way to get pg_dumpall to exclude a table or > do I have to dump the tables indivually with pg_dump? No, pg_dumpall doesn't have any provision for passing different switches for different databases to its invocations of pg_dump. Recommended practice he

Re: [ADMIN] WAL files during a backup

Thanks Steve. If I understand your comment regarding the 16MB limit, it means I should not worry about the WAL file not being copied to the archive directory. I hope this also means a subsequent attempt to restore the db will successfully work since the WAL file is still in the pg_xlog directo

Re: [ADMIN] winsock error 10061 on Vista

Abraham, Danny wrote: > Application cannot connect to PG after successful recovery. > > Happens on both Vista and Server 2008. never happens on XP/2003. > > 2008-08-27 14:05:03.484 FATAL: the database system is starting up > 2008-08-27 14:05:03.609 LOG: database system is ready > 2008-08-27 14:

[ADMIN] excluding tables

Is there a way to get pg_dumpall to exclude a table or do I have to dump the tables indivually with pg_dump? I have one very large table that never changes and it'd be nice not to have a copy of it in every backup (especially since the backups get sent to another machine over the Internet). -- S

[ADMIN] Installing PostgreSQL 8.3.3. on Vista

I tried installing PostgreSQL 8.3.3 on Vista Business, and initdb failed to start during the installer. I'd really like to make this install as automatic as possible since I'm installing PostgreSQL as part of my application installer process. It would be best if the user does not have to deal wit

Re: [ADMIN] Checking Postgres Version Question

2008/8/28 John <[EMAIL PROTECTED]>: > Hi, > > Is there a way to check which version of Postgres is installed on a > particular Linux box without query the RPM database? > > For instance, is there a "psql --version" command, or something similar, > that I can use? > > Thanks, > John > > -- > Sent vi

[ADMIN] Checking Postgres Version Question

Hi, Is there a way to check which version of Postgres is installed on a particular Linux box without query the RPM database? For instance, is there a "psql --version" command, or something similar, that I can use? Thanks, John -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.or

Re: [ADMIN] [GENERAL] PITR - base backup question

> Date: Wed, 27 Aug 2008 06:58:33 -0700 > From: [EMAIL PROTECTED] > Subject: Re: [ADMIN] [GENERAL] PITR - base backup question > To: [EMAIL PROTECTED]; pgsql-admin@postgresql.org; [EMAIL PROTECTED] > > > > > --- On Tue, 8/26/08, Richard Broersma wrote

[ADMIN] winsock error 10061 on Vista

Application cannot connect to PG after successful recovery. Happens on both Vista and Server 2008. never happens on XP/2003. 2008-08-27 14:05:03.484 FATAL: the database system is starting up 2008-08-27 14:05:03.609 LOG: database system is ready 2008-08-27 14:05:10.218 LOG: could not receive da

Re: [ADMIN] WAL files during a backup

Steve, thanks for your response and your question. Ok, here is some clarification on the WAL file name used in the example below. The WAL file name I used in the example is actually 00010088, and the backup file name is 00010088.0089ED8C.backup. The WAL file

Re: [ADMIN] fsync off without a restart

On Wed, Aug 27, 2008 at 5:42 PM, Valentin Bogdanov <[EMAIL PROTECTED]> wrote: > Hi list, > > I have got a script that is inserting, updating heavily at the moment. So, I > want to turn fsync off to speed things up but I don't want to interrupt the > script. > > If I do `postgresql reload` or `kil

[ADMIN] Service goes to maintenance state when stopping postgres

Hi I have solaris 10 update 5 installed. PostgreSQL with SMF is shipped with Solaris 10 update 5. I could see two services installed on the OS. svcs postgresql disabled 14:58:36 svc:/application/database/postgresql:version_81 disabled 15:40:42 svc:/application/database/postgresql:version_82 I f