On 07/11/2016 13:44, Vick Khera wrote:
On Mon, Nov 7, 2016 at 8:23 AM, Howard News wrote:
pg_restore: executing SEQUENCE SET example_seq
pg_restore: processing data for table example_table
pg_restore: [compress_io]
** crash **
What crashes? the pg_restore process or the backend server?
Th
On Mon, Nov 7, 2016 at 8:23 AM, Howard News wrote:
> pg_restore: executing SEQUENCE SET example_seq
> pg_restore: processing data for table example_table
> pg_restore: [compress_io]
>
> ** crash **
What crashes? the pg_restore process or the backend server?
--
Sent via pgsql-general mailing li
On 07/11/2016 13:12, Albe Laurenz wrote:
Howard News wrote:
I have a raid catastrophe which has effectively blitzed a cluster data
directory. I have several pg_dump backups but these will not restore
cleanly. I assume the disk has been failing for some time and the
backups are of the corrupte
Howard News wrote:
> I have a raid catastrophe which has effectively blitzed a cluster data
> directory. I have several pg_dump backups but these will not restore
> cleanly. I assume the disk has been failing for some time and the
> backups are of the corrupted database.
>
> Using a selective pg_
Hi all,
I have a raid catastrophe which has effectively blitzed a cluster data
directory. I have several pg_dump backups but these will not restore
cleanly. I assume the disk has been failing for some time and the
backups are of the corrupted database.
Using a selective pg_restore on the du
On 2011-03-24, Waqar Azeem wrote:
> --0015174766a0ffbf86049f35206e
> Content-Type: text/plain; charset=ISO-8859-1
>
> My XP is crashed and now I have to take a full backup of my postgresql 8.4
>
> I am used to get backup of ldf/mdf files in case of SQLServer
>
> Please let me know the right way of
Waqar,
> my windows event viewer says:
> 2011-03-24 11:24:22 GMT FATAL: could not create lock file "postmaster.pid":
> Permission denied
> is this helpfull?
yes. that says that the windows-user your PostgreSQL Service is
running as has no write priv on the data directory. Check your file
systems
Thanks Karsten n' Raymond,
Finally, I change the logging in account to Local System account as
suggested in your URL. And then change it back to .\postgres
This magically worked for me.
I think ctrl+alt+del was a compulsory part of XP trouble shootings :)
-- Waqar
On Thu, Mar 24, 2011 at 5:10 P
my windows event viewer says:
2011-03-24 11:24:22 GMT FATAL: could not create lock file "postmaster.pid":
Permission denied
is this helpfull?
On Thu, Mar 24, 2011 at 4:31 PM, Waqar Azeem
wrote:
> I copy the whole folder 'Data' to another PC where fresh postgresql 8.4 is
> installed (same as
On Thu, Mar 24, 2011 at 12:37:25PM +0100, Karsten Hilbert wrote:
> > More help is available by typing NET HELPMSG 3534.
...
> > any clue?
And the second Google result has this:
http://archives.postgresql.org/pgsql-bugs/2009-05/msg5.php
Karsten
--
GPG key ID E4071346 @ gpg-keyserv
On 24/03/2011 11:31, Waqar Azeem wrote:
I copy the whole folder'Data' to another PC where freshpostgresql8.4
is installed (same as default config. that previous version have
had)
when i started the server got following ...
The postgresql-8.4 - PostgreSQL Server 8.4 service could not be
started
On Thu, Mar 24, 2011 at 04:31:19PM +0500, Waqar Azeem wrote:
> The postgresql-8.4 - PostgreSQL Server 8.4 service could not be started.
>
> The service did not report an error.
>
> More help is available by typing NET HELPMSG 3534.
>
> The start command returned an error (2)
>
> Press to cont
I copy the whole folder 'Data' to another PC where fresh postgresql
8.4 is installed (same as default config. that previous version have
had)
when i started the server got following ...
The postgresql-8.4 - PostgreSQL Server 8.4 service could not be started.
The service did not report an error
On 03/24/11 12:07 AM, Waqar Azeem wrote:
My XP is crashed and now I have to take a full backup of my postgresql
8.4
I am used to get backup of ldf/mdf files in case of SQLServer
Please let me know the right way of doing this for postgresql 8.4.
you need everything in the $PGDATA directory.
My XP is crashed and now I have to take a full backup of my postgresql 8.4
I am used to get backup of ldf/mdf files in case of SQLServer
Please let me know the right way of doing this for postgresql 8.4.
--
Thanks & Best Regards,
Waqar Azeem
On Wed, 2010-07-14 at 18:18 +0200, easyCity Team wrote:
> Hi guy,
>
> I just droped a development database by mistake using the dropdb command
> witch contains valuable data.
>
> Can I still restaure it ? I have no backup.
No.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
C
Hi guy,
I just droped a development database by mistake using the dropdb command
witch contains valuable data.
Can I still restaure it ? I have no backup.
Best regards,
Romain
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
Christian Schröder wrote:
we have a PostgreSQL 8.2 database on an xfs filesystem. By mistake the
first blocks of this filesystem were overwritten. An xfs_repair
reconstructed the superblock and also found many orphaned files and
directories. Actually, all we have on the filesystem now is in
"l
Hi list,
we have a PostgreSQL 8.2 database on an xfs filesystem. By mistake the
first blocks of this filesystem were overwritten. An xfs_repair
reconstructed the superblock and also found many orphaned files and
directories. Actually, all we have on the filesystem now is in
"lost+found". ;-)
W
Hello!
My filesystem (UFS-FreeBSD) was crashed and I have lost files from
PGSQL DATA DIR FOLDER after fsck-utility.
I have lost files from directory "pg_xlog"
I reset my pg_xlog.
And now have such error by starting pgsql-server:
LOG: database system was interrupted at 2008-03-18 22:29:48 EET
L
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Network Administrator <[EMAIL PROTECTED]> writes:
> >>> PANIC: read of clog file 5, offset 16384 failed: Success
>
> >> Hm, not good :-(. What files actually exist in $PGDATA/pg_clog/ (names
> >> and sizes)?
>
> > -rw---1 postgres users 2621
Network Administrator <[EMAIL PROTECTED]> writes:
>>> PANIC: read of clog file 5, offset 16384 failed: Success
>> Hm, not good :-(. What files actually exist in $PGDATA/pg_clog/ (names
>> and sizes)?
> -rw---1 postgres users 262144 Jul 20 15:53
> -rw---1 postgres users
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Network Administrator <[EMAIL PROTECTED]> writes:
> > ..if I using the psql client, and issue a "select * from name>
> > limit 5" if get this...
>
> > PANIC: read of clog file 5, offset 16384 failed: Success
>
> Hm, not good :-(. What files actually exi
Network Administrator <[EMAIL PROTECTED]> writes:
> ..if I using the psql client, and issue a "select * from
> limit 5" if get this...
> PANIC: read of clog file 5, offset 16384 failed: Success
Hm, not good :-(. What files actually exist in $PGDATA/pg_clog/ (names
and sizes)?
> So back to my
Network Administrator <[EMAIL PROTECTED]> writes:
> PANIC: XLogWrite: write request 5/2D498000 is past end of log 5/2D498000
I'll bet you are running 7.3.3. You need to update to 7.3.4 to escape
this startup bug.
regards, tom lane
---(end of broa
>> How do I do that? I don't know the format of the clog files. The only
>> information I found was in clog.h and xlog.h.
>
> xlog is fairly easy, I think resetxlog or something can work there. For
> clog I just noted from the logs which clog files it was missing and
> created them filled with eith
What operating system and file system? Can I guess Linux/ext2?
---
Christian von Kietzell wrote:
> Hi,
>
> I've got a serious problem. After a horrible filesystem crash the only thing
> left of my database are some files i
> Hmm, presumably you don't have those.
Unfortunately not. All backup measures I took failed on the exact same
occasion - worst case possible.
> I usually start by browsing files by hand to see if I can determine
> from any embedded text which table it was.
Seems easy enough.
> Then if you crea
On Tue, Aug 26, 2003 at 10:17:48AM +1000, Martijn van Oosterhout wrote:
> Wow. Take to pull out those backups...
>
> Hmm, presumably you don't have those. There are programs to read postgresql
> data files however they need to know the exact structure of the table before
> you can even start to de
Wow. Take to pull out those backups...
Hmm, presumably you don't have those. There are programs to read postgresql
data files however they need to know the exact structure of the table before
you can even start to decode them. I usually start by browsing files by hand
to see if I can determine fro
Hi,
I've got a serious problem. After a horrible filesystem crash the only thing
left of my database are some files in /lost+found (with changed names!). Is
there a way to recover the data from those files? I managed to identify the
files belonging to PostgreSQL (unfortunately, these are part of m
If you are sure that no other postmaster is running, try deleting the file
/tmp/.s.PGSQL.5432, as the error message suggests. When you've done that,
you should be able to start the postmaster.
Poul L. Christiansen
On Tue, 8 May 2001, John Clark L. Naldoza wrote:
> Hi,
>
>
> I recently came
Hi,
I recently came across a problem wherein I am not able to start my
postgreSQL 7.0.3 server.
Here's what happens..;-(
postgres@kahoy /root$ postmaster -D /var/lib/pgsql/data
FATAL: StreamServerPort: bind() failed: Permission denied
Is another postmaster already running on that port?
Hi !
I have a big problem : all my datas are unavailable.
When I do a vaccuum, that ok there are rows.
When I do a "SELECT" or "\d", nothing.
One of you told me that could be that I reached the max transaction ID.
My pg_log is very big (1 Go !!)
How could I retrieve my datas ?
Of course I tri
34 matches
Mail list logo
